How to insert the items from DataGridView to Ms Ac

Mangore · October 25th, 2008, 04:39 AM

I was trying this code to insert the items from ListView to Ms Access Table, and It works well with me. How can I insert the item from DataGridView to Ms Access?

Code:

Public conn As New OleDbConnection  
("Provider=Microsoft.Jet.OLEDB.4.0;" _& "Data Source =" &   
Application.StartupPath & "\Store.mdb ")  
'Insert the items to DB-  
TBbillsDim cmd As New OleDbCommand
cmd.Connection =conn
conn.Open()  

Dim i As Integer  
For i = 0 To Form2.DataGridView2.Rows.Count - 1   
cmd.CommandText = "INSERT   
INTO TBbills (BMaterial,BKind) VALUES (@BMaterial,@BKind) "   
cmd.CommandType = CommandType.Text   

cmd.Parameters.AddWithValue("@BMaterial",Form2.DataGridView2.Columns...)   
cmd.Parameters.AddWithValue("@BKind", Form2.DataGridView2.Columns...)  
Public conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" _& "Data Source =" & Application.StartupPath & "\Store.mdb ")'Insert the items to DB-TBbillsDim cmd As New OleDbCommandcmd.Connection = connconn.Open()Dim i As IntegerFor i = 0 To Form2.DataGridView2.Rows.Count - 1 cmd.CommandText = "INSERT INTO TBbills (BMaterial,BKind) VALUES (@BMaterial,@BKind) " cmd.CommandType = CommandType.Text cmd.Parameters.AddWithValue("@BMaterial",Form2.DataGridView2.Columns...) cmd.Parameters.AddWithValue("@BKind", Form2.DataGridView2.Columns...)