sir i want to ask you that how can i fetch or get sql data into texboxes.where

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

Question Posted / atique

1 Answers
3972 Views
I also Faced
E-Mail Answers

sir i want to ask you that how can i fetch or get sql data into texboxes.where i want to show recor..

Answer / 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

More VB.NET Interview Questions

What is branching logic control in VB.NET?

0 Answers

Why do you need Lock in Visual Basic?

0 Answers CGI,

Explain how to store decimal data in .net?

0 Answers

Tell me how many .net languages can a single .net dll contain?

0 Answers

How do you script this scenario in QTP using VB? Verify XML attributes in XML message against XSD and data mapping of fields to Oracle tables? Verify data in XML to data in a defined table?

0 Answers Perot Systems,

What is datatype conversion?

0 Answers

Explain enumerator?

0 Answers

How a base class method is hidden?

0 Answers

what is common language specification?

0 Answers

How to run a dos command in vb.net?

0 Answers

Regarding Types of compatability in VB and their usage ?

1 Answers Satyam,

difference between control and component more than one differences

0 Answers

For more VB.NET Interview Questions Click Here