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 are the Data providers in ADO.Net?

1019

---

What are the key events of sqlconnection class?

1194

---

What is the difference between Dataset. clone and Dataset.copy?

1049

---

What providers does Ado.net uses?

1022

---

What is difference between datareader and dataadapter?

1051

---

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

976

---

What is ado net stands for?

970

---

What is partial class?

985

---

Which database is the ado.net sql connection object designed for?

1050

---

What are the different ado.net namespaces are available in .net?

1010

---

What is bubbled event?

975

---

Define isolation?

969

---

Describe the command object and its method.

1004

---

What is ado and rdo?

902

---

Is it possible to edit data in Repeater control?

966

---