1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
|
void Button1_Click(object sender, EventArgs e)
{
System.Text.StringBuilder query = new System.Text.StringBuilder();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row = GridView1.Rows[i];
string value1 = ((TextBox)row.Cells[0].FindControl("txtFirstName")).Text.Replace("'", "''");
string value2 = ((TextBox)row.Cells[1].FindControl("txtLastName")).Text.Replace("'", "''");
string value3 = GridView1.DataKeys[i].Value.ToString();
query.Append("UPDATE [Etudiant] SET [Nom] = '")
.Append(value1).Append("' , [CNE] = '")
.Append(value2).Append("' WHERE [NUM_INSCRIPTION] = '")
.Append(value3).Append("';\n");
}
System.Data.SqlClient.SqlConnection con= new System.Data.SqlClient.SqlConnection(@"Data Source=.\SQLEXPRESS;UID=sa;Password=xxxx;Initial Catalog=bd1");
//SqlConnection con = new SqlConnection(ConfigurationSettings.ConnectionStrings["ConnectionString9"].ConnectionString);
System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand(query.ToString(), con);
con.Open();
command.ExecuteNonQuery();
con.Close();
} |
Partager