Sequence to connect and retrieve data from database useig
dataset ?
Answer Posted / ashokdahiya
We r talking about vb.net not c# codding
system.data
system.data.sqlclient
dim con,s as string
con="Server=servername;database=name;uid=sa;pwd=;"
s="Select * from tablename"
dim ad as new sqldataadapter(s,con)
dim ds as dataset
ad.fill(ds)
dim dv as dataview= new dataview(ds.tables("tablename"))
dv.sort="Name desc"
listbox.datasource=ds
listbox.displayMember="Name"&"Age"&"sex"...
it will work fine thanx!
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
What are the steps you will take to improve performance? Will you use dataset or datareader?
What two types of data providers does ADO.NET supply? What determines which one you should use?
Explain sqlconnection object?
What is a data control clerk?
What is Dataset Object?
How many major types of connection objects in ADO.NET?
What are the features of ado.net?
What is the DataTableCollection?
What are the classes in System.Data.Common Namespace?
What is the difference between executequery and executenonquery?
How does entity framework work?
What is data reader in ado.net?
What is ado.net and its architecture?
differance between ADO vs ADO.Net?
Define executenonquery?