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 is ado.net components?
How to add a check box or a dropdown list to a column in a datagrid?
If a table contains 20000 records. In a page at each time 100 records to be displayed.
What is ado data control?
What is the difference between data grid and data repeater?
What two types of data providers does ADO.NET supply? What determines which one you should use?
What is ado rdo dao in visual basic?
What is the difference between executenonquery () and executescalar ()?
describe the dataset object in ado.net.
What is openrowset?
How to add an aggregate column?
Explain the architecture of ado.net?
What is the use of SqlCommand object?
What are good ado.net object to replace to ado recordset object.
What is maximum pool size in ado.net connection string?