What is the default provider in ado.net?
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
What are the data providers used in ado.net
What is a dataset?
What is sql connection in ado.net?
What are the parameters that control most of connection pooling behaviors?
Define ado.net?
Name which operations can you not perform on an ado.net dataset?
Which is faster datareader or dataadapter?
What are the steps in connecting to database?
Does executenonquery return a value?
IF we have lot of records in Database. How we can handle them?
suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validation contrl for dd/mm/yy formator how we assign regular expression for same