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


Please Help Members By Posting Answers For Below Questions

What is global assembly cache (gac)?

753


What is difference between metadata and manifest?

814


What is the difference between manifest and metadata?

743


What is late binding and early binding?

773


What is pre-jit?

722


What are the different variables in vb.net?

711


What is econo-jit?

795


What is static member?

770


What does assert() method do In VB.NET

731


What are the advantages of an assembly?

831


What is the top .net class that everything is derived from?

834


Explain about Visual basic.NET culture?

789


What is the source code for display the picture in button click event?

906


Explain an assembly and its use?

711


Explain the difference between .dll extension and .exe extension files?

774