Gridview Problem

9y789.NET

Helo, i want to update Gridview Asp.net using C# Date not Updated please Help

///Gridview///

onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"

onrowupdating="GridView1_RowUpdating" onrowupdated="GridView1_RowUpdated">

///GridView Updating Code///

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

String ID = GridView1.Rows[e.RowIndex].Cells[0].Text;

String ClassName = GridView1.Rows[e.RowIndex].Cells[1].Text;

obj.con.Open();

obj.qry = "update Classreg set ClassName=@ClassName where ID=@ID";

obj.cmd = new SqlCommand(obj.qry, obj.con);

obj.cmd.Parameters.AddWithValue("ClassName", TextBox2.Text);

obj.cmd.Parameters.AddWithValue("ID", TextBox1.Text);

obj.cmd.ExecuteNonQuery();

obj.con.Close();

Response.Write(@"");

filldata();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

filldata();

}

7 Replies

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

9y ago
i am updating from grid data
Rafnas T P9y ago
are you updating data from text boxes or from grid data
if its fro grid data then
change these lines

obj.cmd.Parameters.AddWithValue("ClassName", TextBox2.Text);
obj.cmd.Parameters.AddWithValue("ID", TextBox1.Text);

to

obj.cmd.Parameters.AddWithValue("@ClassName", ClassName);
obj.cmd.Parameters.AddWithValue("@ID", ID );
9y ago
there is no Error Message Runs Seccessfully ,so Data in DB Not Updated Still
Rafnas T P9y ago
obj.cmd.Parameters.AddWithValue("ClassName", TextBox2.Text);
obj.cmd.Parameters.AddWithValue("ID", TextBox1.Text);

change to

obj.cmd.Parameters.AddWithValue("@ClassName", TextBox2.Text);
obj.cmd.Parameters.AddWithValue("@ID", TextBox2.Text);

or

if your Id is GridView1.Rows[e.RowIndex].Cells[0].Text
and ClassName is GridView1.Rows[e.RowIndex].Cells[1].Text

then

obj.cmd.Parameters.AddWithValue("@ClassName", ClassName);
obj.cmd.Parameters.AddWithValue("@ID", ID );
Amit Gupta9y ago
Need to pass @
obj.cmd.Parameters.AddWithValue("@ClassName", TextBox2.Text);
obj.cmd.Parameters.AddWithValue("@ID", TextBox1.Text);
9y ago
Sorry its Mistake Bro Not Date , its a Data not Updated Seccessfully i am using only 2 coloums ID and ClassName
Amit Gupta9y ago
Where is the date part?

Process of passing date is the same as you had passed ID
cmd.Parameters.AddWithValue("@date", DateTime.Now);

If its not, do let me know