sir i want to ask you that how can i fetch or get sql data
into texboxes.where i want to show record in specific
texboxes related to student information.when i click on
button all data show on texboxes when i put id or name
plz inform me on my id
Answer Posted / amit dixit
1)Create an object of CurrencyManager.
2)Take the values fetch from the table to DataView.
3)Convert dataview to type of Currency Manager.
eg:EMP Table.
Dim da As New SqlDataAdapter("SELECT * FROM EMP", sqlCon)
Dim ds As DataSet
Dim dv As DataView
Dim objCm As CurrencyManager
======================
ds = New DataSet
da.Fill(ds, "EMP")
dv = New DataView(ds.Tables("EMP"))
objCm = CType(Me.BindingContext(dv), CurrencyManager)
======================
txtEmpid.DataBindings.Clear()
txtFnm.DataBindings.Clear()
txtDeptno.DataBindings.Clear()
txtEmpid.DataBindings.Add("Text", dv, "EmpId")
txtFnm.DataBindings.Add("Text", dv, "FirstName")
txtDeptno.DataBindings.Add("Text", dv, "DeptNo")
You can iterate through the next and previous by using
Position property of CurrencyManager.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define clr?
What is the difference between datagrid and gridview?
Which classes a dll can contain?
what is diffrence constructor and destructor in vb
Explain the use of console application?
Explain the difference between int and int32?
List the two main parts of .net?
Which dll is used for microsoft .net run time?
What is the difference between a "jagged array" and multidimensional array" ?can anyone show me it practically ?
What is the feature anonymous type?
What is the difference between .dll extension and .exe extension files?
Why do you need Lock in Visual Basic?
What are all the differences between dispose and finalize()?
What is the use of system.diagnostics.process class?
Why should you use delegate?