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 5456oledbdataadpter 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?
2381The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
2029i 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 17951what purpose of Indexing creating? directly we can search the reqired row with the help of query?what is the use of indexing?
3 13763explain 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 17051
Can we load multiple tables in a dataset?
What is ado.net object model?
What are the key events of sqlconnection class?
What are all features of ADO.Net?
Explain the difference between data reader and data set?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
Command objects uses, purposes and their methods.
What is ole db query?
What is untyped dataset?
What are the advantages of oledb compared with other classes?
What are the pre-requisites for connection pooling?
What is ado.net objects?
What is the difference between the clone() and copy() methods of the dataset class?
What is aggregating data ?
What are the essential features of ado.net?