help sending dataGrid Rows to Access Table. , C#

help sending dataGrid Rows to Access Table.

//Rextester.Program.Main is the entry point for your code. Don't change it.
//Compiler version 4.0.30319.17929 for Microsoft (R) .NET Framework 4.5

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text.RegularExpressions;

namespace Rextester
{
    public class Program
    {
        public static void Main(string[] args)
        {
            private void btnSendTBL1_Click(object sender, EventArgs e)

{

OleDbConnection con = new OleDbConnection();

con.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;

Data Source=C:\User\Test.accdb";

con.Open();

OleDbCommand command = new OleDbCommand();

command.Connection = con;

for (int i=0; i<dGview.Rows.Count; i++)

{

string AccessDB = "insert into table (A,B,C) values ("

+ dGview.Rows[i].Cells[0] + ","

+ dGview.Rows[i].Cells[1] + ","

+ dGview.Rows[i].Cells[2] + ");";

command.CommandText = AccessDB;

command.ExecuteNonQuery();

}

con.Close();

}
        }
    }
}


run \| edit \| history \| help	0

λ

                                      .NET NoSQL database for rapid development