Update button in datalist....

hi gopal,

sorry for the wrong code . i did not check that. now try following code i checked that.

in aspx:


 
 
  '>
  '>
 

 
 

 
 
 

in cs:

 protected void accept1_Click(object sender, EventArgs e)
  {
  con.Open();
  Button b = (Button)sender;
  DataListItem row = (DataListItem)b.NamingContainer;
  Label ID = (Label)row.FindControl("Label1");
  SqlCommand cmd = new SqlCommand("update friends set friendstatus='Y' where myid='" + ID.Text + "' AND friendid='" + Session["myid1"] + "'", con);
  cmd.ExecuteNonQuery();
  Response.Write("thanx");
  con.Close();

  }

for second button

protected void not_Click(object sender, EventArgs e)
    {
        con.Open();
        Button c = (Button)sender;
        DataListItem row = (DataListItem)c.NamingContainer;
        Label ID = (Label)row.FindControl("Label1");
        SqlCommand cmd = new SqlCommand("update friends set friendstatus='N' where myid='" + ID.Text + "' AND friendid='" + Session["myid1"] + "'", con);
        cmd.ExecuteNonQuery();
        Response.Write("thanx");
        con.Close();

    }


hope it will help you