Write steps of retrieving data using ado.net ?
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
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do you merge 2 datasets into the third dataset in a simple manner?
What are the uses of Stored Procedure?
What is data view and variable view?
Define ado.net?
What is sqldatareader?
How to generate a single aggregate?
Which parameter of ConnectionString is used to specify the name of the database?
What is the advantage of ado.net?
Explain the architecture of ado.net?
How does entity framework work?
Which database is the ado.net sql connection object designed for?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
What does ado stand for in ado.net?
What are the important features of ado.net 2.0?