Need help with Inserting data into a SQL db

Question

Excuse my English. I am totally new to Windows Forms and database Access I am sorry.... This is the code I have for looking up in the database: oleDbDataAdapter1.SelectCommand.Parameters[simi].Value = simi.Text; dataSet11.Clear(); oleDbDataAdapter1.Fill(dataSet11); And this is how I have been trying to add stuff into the database: oleDbDataAdapter1.InsertCommand.Parameters[nafn].Value = nafn.Text; oleDbDataAdapter1.InsertCommand.Parameters[heimilisfang].Value = heimili.Text; oleDbDataAdapter1.InsertCommand.Parameters[simi].Value = simi.Text; Can any of you geniouses tell me what I am doing wrong ?

p.jones · Answer

DataAdapter.Update method works primarily off of DataTable trying to write rows back to the database table from the in - memory DataTable. If that is all you want to do then you in fact add rows to the DataTable then those rows will be marked with a RowState of added then you call the Datatable Update method either on the whole set of DataRows or on a selection of datarows based on RowState. Look it up in Visual Studio Help by searching on these terms and also searching on DataSet. Parameters have their place but I don't think that is the bread and butter way to update your tables on a row by row insert basis. I think that is for queries that update sets of rows that already exist in te database and then you probably need a DataAdapter object a Command object on top of a Connection object with a query string and placeholders therein for parameters and a Parameters object to supply values woul dprobably be enough.

sp3rmy · Answer

oleDbDataAdapter1.SelectCommand.Parameters[simi] The above is something u use with stored procedures in the database since ur new to all of this i don't think you are using any... Just look it up in google coz this is basic stuff should be easy to find.