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
- 3847 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
Name some of the keywords used in vb.net?
Explain the services provided by common language infrastructure.
What is the feature anonymous type?
What is difference between metadata and manifest?
What is the maximum size of the textbox?
What is late binding?
Before in my vb app I would just load the icons from dll. How can I load the icons provided by .net dynamically?
Explain the difference between datatable and dataset?
What do you mean by option strict on?
What are the advantages of vb.net and c#?
What is redim keyword and its use?
How to store decimal data in .net?
Explain and brief about rapid application development tool?
Explain an assembly and its use?
How does vb.net achieve polymorphism?
