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!

What is ado.net components?

957

---

How to add a check box or a dropdown list to a column in a datagrid?

967

---

If a table contains 20000 records. In a page at each time 100 records to be displayed.

886

---

What is ado data control?

991

---

What is the difference between data grid and data repeater?

1072

---

What two types of data providers does ADO.NET supply? What determines which one you should use?

986

---

What is ado rdo dao in visual basic?

1164

---

What is the difference between executenonquery () and executescalar ()?

951

---

describe the dataset object in ado.net.

952

---

What is openrowset?

974

---

How to add an aggregate column?

1005

---

Explain the architecture of ado.net?

1058

---

What is the use of SqlCommand object?

1220

---

What are good ado.net object to replace to ado recordset object.

1113

---

What is maximum pool size in ado.net connection string?

970

---