protected void StudUpdate(object sender, GridViewUpdateEventArgs args)
{
string StudentId = ((Label)GridView1.Rows[args.RowIndex].FindControl("Label1")).Text;
string FirstName = ((Label)GridView1.Rows[args.RowIndex].FindControl("Label2")).Text;
string LastName = ((Label)GridView1.Rows[args.RowIndex].FindControl("Label3")).Text;
string Address = ((Label)GridView1.Rows[args.RowIndex].FindControl("Label4")).Text;
string StudMail = ((Label)GridView1.Rows[args.RowIndex].FindControl("Label5")).Text;
string StudPhone = ((Label)GridView1.Rows[args.RowIndex].FindControl("Label6")).Text;
string Gender = ((Label)GridView1.Rows[args.RowIndex].FindControl("Label7")).Text;
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
con.Open();
cmd.CommandText = "update Student set FirstName=@p2," + "LastName=@p3," + "Address=@p4," + "StudMail=@p5," + "StudPhone=@p6," + "Gender=@p7 where StudentId=@p1;" + "select StudentId,FirstName,LastName,Address,StudMail,StudPhone,Gender from Student";
cmd.Parameters.Add("@p1", SqlDbType.NChar).Value = StudentId;
cmd.Parameters.Add("@p2", SqlDbType.NVarChar).Value = FirstName;
cmd.Parameters.Add("@p3", SqlDbType.NVarChar).Value = LastName;
cmd.Parameters.Add("@p4", SqlDbType.NVarChar).Value = Address;
cmd.Parameters.Add("@p5", SqlDbType.NVarChar).Value = StudMail;
cmd.Parameters.Add("@p6", SqlDbType.NChar).Value = StudPhone;
cmd.Parameters.Add("@p7", SqlDbType.NVarChar).Value = Gender;
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds,"Student");
GridView1.EditIndex = -1;
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
BindData();
}
Premalatha
Software Engineer
Reply |
Reply with attachment |
Alert Moderator