Write steps of retrieving data using ado.net ?

Answers were Sorted based on User's Feedback



Write steps of retrieving data using ado.net ?..

Answer / senthil kumar

we can use two ways to retrieve the data from database
1 -> data reader
2 -> data adapter

when you use datareader
create connection object and open the connection
SqlCommand cmd = new SqlCommand(sql,con);
cmd.CommandType = CommandType.Text;
SqlDataReader sread = cmd.ExecuteReader();
while(sread.Read())
{
String data1 = sread.GetString(0);
int data2 = sread.GetValue(1);
String data3 = sread.GetString(2);
}

when u use the dataadapter

create the connection and open
SqlDataAdapter sda = new SqlDataAdapter(sql,con);
DataSet ds = new DataSet();
sda.Fill(ds,"customer");

then use can get the data in row wise or directly assign
the data to the controls through datasource.

i think its enough.If i did any mistake correct me.

Is This Answer Correct ?    13 Yes 1 No

Write steps of retrieving data using ado.net ?..

Answer / sudheer lakkireddy

Take a gridview control in ur design
add
using system.data.sqlclient;
using.system.data;
// give a connection string to database

sqlconnection con= new sqlconnection("conn");

//in button click event write following

sqldataadapter da=new sqldataadapter("select * from
(tablename)",con);
dataset ds=new dataset();
da.fill(ds,"tablename");
gridview1.datasource=ds;
gridview1.datamember="tablename";
gridview1.databind();

try out this

Is This Answer Correct ?    4 Yes 1 No

Write steps of retrieving data using ado.net ?..

Answer / 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

More ADO.NET Interview Questions

How can we load multiple tables in to dataset?

0 Answers  


What is the role of data provider in ado.net?

0 Answers  


Which method in OLEDBAdapter is used to populate dataset with records?

0 Answers  


Describe the disconnected architecture of ADO.NET’s data access model.

0 Answers  


What is ado.net connection?

0 Answers  






What are the advantages of oledb compared with other classes?

0 Answers  


how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

0 Answers  


What do you mean by ‘batch updates’?

0 Answers  


How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

0 Answers   CGI,


Difference between OLEDB Provider and SqlClient ?

2 Answers  


What is serialization and de-serialization in .net?

0 Answers  


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

0 Answers  


Categories