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!

Define different execute methods of ADO.NET command object ?

1018

---

What is the difference between ado.net and oledb?

913

---

Define Execute Scalar?

969

---

What are typed and untyped dataset?

1058

---

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

1003

---

What is csdl entity framework?

976

---

What is ado asp?

956

---

How can we save all data from dataset?

947

---

How to check if the Dataset has records ?

952

---

What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

935

---

What is data adapter in ado.net with example?

960

---

What are the connected and disconnected modes in ado.net?

867

---

What is Data view?

1012

---

Explain ado.net features? Benefits? Drawbacks?

994

---

What is command class in ado.net?

954

---