Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 3927 Views
- I also Faced
- E-Mail Answers
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
Can you please explain the difference between vb and vb.net?
Can you please explain the difference between authentication and authorization?
difference between checkbox vs radiobutton??
What is sealed class?
How can I extract the formated word(bold,italic,underline,font,color etc) from the msword file.?
What are the advantages of an assembly?
Explain the difference between value and reference types?
Explain the advantages of vb.net?
What is the difference between compiler and interpreter?
What are the differences between server-side and client-side code?
Described strong typing
What is an application domain? how they get created?
Compare c# and visual basic.net?
Explain cts?
Why do we use ansi keyword?
