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
1 4800oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?
1918The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
1562i have two textboxes one for user name and another for password . i have a table name compare(which contains name,passwod etc.,)my doubt is how compare username textbox with name column and how compare password textbox with passwod column. i want the code
9 15293what purpose of Indexing creating? directly we can search the reqired row with the help of query?what is the use of indexing?
3 12338explain connection less and with connection?diference between data reader,data set,data adapter? can we use data reader,data set in a single application? if yes explain with simple code,if no explain?
3 15860
Can we connect two dataadapters to same data source using single connection at same time?
What is disconnected architecture in ado.net?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What is ado or jdbc?
What is a datareader object?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
Name which operations can you not perform on an ado.net dataset?
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
What is command class in ado.net?
What is ado.net code?
Where is adodb dll located?
What is the use of adodc?
Explain executenonquery?
Is bulk insert faster than insert?