Save Dataset to table sql server in window form c #

1

good afternoon I'm making a datatable saved in a sql server table but I get the following error:

this is my code:

DataSet result;
   dataGridView1.DataSource = result.Tables[cboSheet.SelectedIndex];


            //string valor = dataGridView1.CurrentRow.Cells[4].Value.ToString();



            foreach (DataRow r in dataGridView1.Rows)
                {
                SqlConnection con = new SqlConnection(ObtenerCadenaConexion());
                con.Open();

    string sql = "INSERT INTO NumeroCredito (Numero1, Numero2) VALUES ('" + r["Columna3"] + "', '" + r["Columna5"] + "')";
                SqlCommand cmd = con.CreateCommand();
                cmd.CommandText = sql;
                    cmd.Parameters.AddWithValue("@A", r["A"]);
                    cmd.Parameters.AddWithValue("@B", r["B"]);

                    cmd.ExecuteNonQuery();
                }
    
asked by PieroDev 30.08.2017 в 05:32
source

1 answer

1

Good morning.

Try the following; instead of the GridView.Rows it uses the DataTable.Table.Rows; since from this last you know which Tables to use:

foreach (DataRow r in result.Tables[cboSheet.SelectedIndex].Rows)
{
   SqlConnection con = new SqlConnection(ObtenerCadenaConexion());
   con.Open();

   string sql = "INSERT INTO NumeroCredito (Numero1, Numero2) VALUES ('" + r["Columna3"] + "', '" + r["Columna5"] + "')";
   SqlCommand cmd = con.CreateCommand();
   cmd.CommandText = sql;
   cmd.Parameters.AddWithValue("@A", r["A"]);
   cmd.Parameters.AddWithValue("@B", r["B"]);

   cmd.ExecuteNonQuery();
}
    
answered by 30.08.2017 / 05:42
source