Answer Posted / ashokdahiya

We can retrieve data in following ways in .net
1st we have to create connection object through sqlclient or
oledb provider.then open connection
2nd We can choose datacommands or data adapter(by sqlclint
or oledb dataprovider
system.data
system.data.oledb //to oledb adapter
system.data.sqlclient //to sqlclient adapter
dim con as new connection
con=("provider=oledb;initial
catalog=databasename;userid=sa;paswd=;data source=servername;")
con.open
dim query as string="select* from tabel"
dim ad as new oledb.oledbprovider(query,con)
dim ds as dataset
ad.fill(ds)
dim dt as new datatable()
dt=ds.table(0) //is for ist tabel
dim dr() as datarow //it is array becouse it contain all
rows and coulmn for table
dr()=dt.select("") //blank for all coulmns and rows
for i as integer=0 to dr.length-1.tostring
if dr(i)("empid")=textbox.text then
listbox1.items.add(dr(i)("firstname")&
dr(i)("lastname")& dr(i)("email"))
//it will add records of perticular row that matches to the
textbox text in listbox.suppose u enter a001 if it is valide
id then the all records of a001 r added into the list box.//
next

it will work fine.try thanks

What are the objects of ado.net?

1120

---

What is an ado connection?

1037

---

What does executenonquery () method return?

988

---

What is ado.net tutorial?

1001

---

What is connected architecture in ado.net?

1183

---

What are datareaders?

1027

---

What is a dataview?

1032

---

Define table relations?

1034

---

What are the advantages using ado.net?

1088

---

What is dataadapter in ado.net?

962

---

Data reader read and forward only, how is it possible to get 2 tables of data at a time?

966

---

Explain the two fundamental objects in ado.net?

1070

---

What is a sqldataadapter?

1057

---

What is the difference between Command and CommandBuilder object?

1346

---

What are the steps you will take to improve performance? Will you use dataset or datareader?

1049

---