C# dding data from parameter "access" to "Datatable"

Hi,

The following is added to the acces table with "using" in the code painted with the red. this takes a long time if the number of lines is too high. so how can I translate this section to the "Datatable" object

Exam :

DataTable dt = new DataTable();

dt.Columns.Add("periodclumb", typeof(string));

....

??????

void start()

{

for (int i = 0; i < datagrid1.RowCount; i++)

{

if (datagrid1.Rows[i] != null && datagrid1.Rows[i].Cells[1].Value != null)

{

DateTime d = DateTime.Parse(datagrid1.Rows[i].Cells[1].Value.ToString());

Insertrow(d.ToString("dd.MM.yyyy"));

}

void Insertrow(string cell)

{ DateTime period;

string ncell = cell.Replace('.', '-');

if (DateTime.TryParseExact(ncell, "dd-MM-yyyy", null, DateTimeStyles.None, out period))

{ Insertperiod(period.AddMonths(-1)); Insertperiod(period); } }

void Insertperiod(DateTime period)

{

using (var conn = new OleDbConnection("Provider=" + "Microsoft.Jet.OLEDB.4.0" + "; Data Source=" + mdbpatch))

using (var cmd1 = conn.CreateCommand())

{

cmd1.Connection.Open();

cmd1.CommandText = "insert into billtable (periodclumb) values (?)";

cmd1.Parameters.AddWithValue("?", period.ToString("MM/yyyy").Replace('.', '/'));

cmd1.ExecuteNonQuery();

}

2 Replies

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

Kalyani Shevale8y ago
Accepted answer
follow this link

https://stackoverflow.com/questions/9022118/access-cell-value-of-datatable

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/updating-data-sources-with-dataadapters
Mehmet Yilmaz8y ago
Kalyani Shevale Tahanks,

I have reviewed the links tell very simple.

in fact, all I have to do is to convert "acces" in this code to "Datatable". I couldn't find the method of adding data to the "Data table" object with the parameter. Datatable to add data and read data is extremely fast. but I haven't found a sample or path to that. isn't there an expert who can re-edit the code for me?