la requête update ne s’exécute pas
bonjour;
voila mon code :
Code:
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
| public partial class demandes : System.Web.UI.Page
{
SqlConnection cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\nouass\Documents\Visual Studio 2010\WebSites\pfe\App_Data\WRKFLOW.mdf;Integrated Security=True;User Instance=True");
SqlCommand cmd;
SqlDataReader dr;
protected void Page_Load(object sender, EventArgs e)
{
Label2.Text = Session["Matricul"].ToString();
TextBox1.Text = DateTime.Now.ToString("dd/MM/yyyy");
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (((System.Web.UI.WebControls.Button)GridView1.Rows[0].Cells[8].Controls[1]).ID == "Button1")
{
cn.Open();
cmd = new SqlCommand(@"UPDATE cos set matrval=@matrval ,dateval=@dateval where mat=@matS and dateop=@dateopS ;", cn);
cmd.Parameters.Add("@matrval", System.Data.SqlDbType.Int).Value = (Label2.Text);
cmd.Parameters.Add("@dateval", System.Data.SqlDbType.Date).Value = (TextBox1.Text);
cmd.Parameters.Add("@matS", System.Data.SqlDbType.Int).Value = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[0].Text);
cmd.Parameters.Add("@dateopS", System.Data.SqlDbType.Date).Value = Convert.ToDateTime(GridView1.Rows[e.RowIndex].Cells[3].Text);
dr = cmd.ExecuteReader();
MessageBox.Show("Validation enregister");
Response.Redirect("demandescos.aspx");
}
else
{
}
GridView1.EditIndex = -1;
} |
qaund je Click on m'affiche le messagebox mais dans ma table ya rien du tout
qui peut m'aider svp ?
