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
- 3971 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
What is vb.net used for?
what is common type system?
Explain about garbage collection?
What do you mean by Redim in VB.NET?
Why do you need Lock in Visual Basic?
Explain the use of new keyword?
i have two class that contain's two methods as same name in derived class i have to call these two methods what will happen at run time ?
Explain an assembly and its use?
What is stack used for in vb. Net?
What is the size of .net object?
Explain internal keyword in .net framework?
What is enumerator?
What is the top .net class that everything is derived from?
Explain about branching logic control in vb.net?
What are the assembly entry points?
