In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What are the advantages and disadvantages of using datalist?
How to pass values into a datatable?
what is data Adapter?
26 Answers CMC, CSS, IBM,
What is difference between sqldatareader and sqldataadapter?
what are the differences between dataset and datareader?
What is azure ado?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
What are the steps you will take to improve performance? Will you use dataset or datareader?
Explian About DataAdapters
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it
How to add an aggregate column?