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 the difference between sqlcommand and sqldataadapter?

1037

---

What is the difference between Response.Expires and Reponse.ExpiresAbsolute?

1074

---

Explain sqlconnection object?

1065

---

Define data adapter?

1020

---

What is oledb driver?

994

---

What are typed and untyped dataset?

1147

---

What do you know about ado.net's objects?

1073

---

Define table relations?

1030

---

Explain the difference in an abstract class and an interface?

971

---

What are the data providers used in ado.net

1061

---

Is it possible to load multiple tables in a Dataset?

1141

---

What is the hierarchy of data in databases?

988

---

What is the difference between Data adaptor and Data set?

1093

---

How to enable and disable connection pooling?

1107

---

How can we add relation between tables in a dataset?

1043

---