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 you mean by filtering of data?

974

---

What is data relation?

925

---

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

971

---

What is untyped dataset?

1094

---

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

1125

---

What is the use of SqlCommand object?

1230

---

What are the key events of sqlconnection class?

1196

---

How can we add relation between tables in a dataset?

1000

---

What are the parameters that control most of connection pooling behaviors?

1012

---

What is an ado?

986

---

What are all features of ADO.Net?

984

---

What is the difference between Data adaptor and Data set?

1041

---

What are all the different methods under sqlcommand?

989

---

What are all the different authentication techniques used to connect to MS SQL Server?

1089

---

What we do with the object of ado.net dataset after using it?

1047

---