How do I insert data to a DB?

cshacon

Hello I'm working with an Access DB, and I'd like to insert new rows to it. How do I do that? I've searched the MSDN library, and it goes on and on about DataAdapter and DataSet, but I didn't understand how to use it.. :\ Am I supposed to copy the entire DB to the DataSet, make changes in it, set an InsertCommand to the DataAdapter and then do dataadapter.update? I didn't understand what the DataSet is used for, or how to do it.. Can you please help me?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

akbhattacharya22y ago
Hi Arik.. Go through it... it will help you. The following code will be inside Insert_data Button..... 'First set the connection to the .mdb access database. Dim OleDbCon1 As OleDbConnection Dim ConStr As String ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=//the address of the mdb file//;Persist Security Info=False" OleDbCon1 = New OleDbConnection() OleDbCon1.ConnectionString = ConStr 'Open the database OleDbCon1.Open() 'Prepare the SELECT statement Dim CmdText As String="INSERT INTO Emp VALUES('EmpId', 'EmpName')" 'Create a OleDbCommand Dim Cmd As OleDbCommand = New OleDbCommand() Cmd.Connection = OleDbCon1 Cmd.CommandText = CmdText 'Now execute this query Cmd.ExecuteNonQuery() '///////// You can put it in a try.. catch.. end try... for safe side. 'Finally close everything DataReadr.Close() Cmd.Dispose() OleDbCon1.Close() Isn't it really simple... try it, and lemme know.. Baan **** Note: Dont forget to import System.Data.OleDb at the starting. (Imports System.Data.OleDb)
xkabuff22y ago
if u are not familiar with datasets and do not wish to use them u can also use the datareader...for example: Conn.Open(); cmPpls.CommandText = "INSERT INTO PEOPLE (Name, Surname, Email) VALUES ('" +txtName.Text+ "','"+txtSurname.Text+"', '"+txtEmail.Text+"')"; cmPpls.ExecuteNonQuery(); Conn.Close(); if ur program uses a lot of tables that has a lot of records stored in them datasets are always better tho.
amin choroomi22y ago
hi data set is an image from ur datas drived with data adapter. i mean a dataadapter makes a select query and contains some rows of database. then that fill the dataset dataset11.clear() oledbdataadapter1.fill(dataset11.tablename) ur now work with dataset no real db. when u need to addnew row to the dataset type: dataset11.tablename.addnewtablename(Field1,Field2,...) oledbdataadapter1.update(dataset11.tablename)