datagrid üzerindeki verileri veri kaynağına kaydetmek

            OleDbCommand komut = new OleDbCommand("SELECT * FROM [Sayfa1$]", bağlantıexcel); 
            OleDbDataReader oku = komut.ExecuteReader();
            while (oku.Read()) 
            {
                bağ.Open();
                OleDbCommand kmt = new OleDbCommand("insert into tblprg (i1,i2) values ('" + oku["i1"].ToString() + "','" + rgx.Replace(oku["i1"].ToString(),"") + "')", bağ);
                kmt.ExecuteNonQuery();
                kayitsay++;
                bağ.Close();
            }

        SqlBulkCopy sbc = new SqlBulkCopy(baglanti);
        bulkcopy.WriteToServer(dt);

public static string GenerateInsert(DataTable table)
{
    var names = new List<string>();
    foreach (DataColumn col in table.Columns)
    {
        names.Add("[" + col.ColumnName + "]");
    }
    var output = new StringBuilder();
    output.AppendFormat("INSERT INTO [{0}]\n\t({1})\nVALUES ", table.TableName, string.Join(", ", names.ToArray()));
    bool firstRow = true;
    foreach (DataRow rw in table.Rows)
    {
        if (firstRow)
        {
            firstRow = false;
            output.AppendLine("");
        }
        else
        {
            // there was a previous item, so add a comma
            output.AppendLine(",");
        }
        output.Append("\t(");
        output.Append(GetInsertColumnValues(table, rw));
        output.Append(")");
    }
    return output.ToString();
}
public static string GetInsertColumnValues(DataTable table, DataRow row)
{
    var output = new StringBuilder();
    bool firstColumn = true;
    foreach (DataColumn col in table.Columns)
    {
            if (firstColumn)
            {
                firstColumn = false;
            }
            else
            {
                output.Append(", ");
            }
            output.Append(GetInsertColumnValue(row, col));
    }
    return output.ToString();
}
public static string GetInsertColumnValue(DataRow row, DataColumn column)
{
    string output = "";
    if (row[column.ColumnName] == DBNull.Value)
    {
        output = "NULL";
    }
    else
    {
        if (column.DataType == typeof(bool))
        {
            output = (bool)row[column.ColumnName] ? "1" : "0";
        }
        else
        {
            bool addQuotes = false;
            addQuotes = addQuotes || (column.DataType == typeof(string));
            addQuotes = addQuotes || (column.DataType == typeof(DateTime));
            if (addQuotes)
            {
                output = "'" + row[column.ColumnName].ToString() + "'";
            }
            else
            {
                output = row[column.ColumnName].ToString();
            }
        }
    }
    return output;
}

string SQLKodu = generateInsert(dt);

OleDbCommand komut = new OleDbCommand("SELECT * FROM [Sayfa1$]", bağlantıexcel); 
OleDbDataReader oku = komut.ExecuteReader();
StringBuiledr sb = new StringBuilder();
while (oku.Read()) 
{
	sb.Append(String.Format("insert into tblprg (i1,i2) values ('{0}','{1}');\r\n", oku["i1"], rgx.Replace(oku["i1"].ToString(),""));
    kayitsay++;
}
bağ.Open();
OleDbCommand kmt = new OleDbCommand(sb.ToString(), bağ);
kmt.ExecuteNonQuery();
bağ.Close();