protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; string constr = ConfigurationManager.ConnectionStrings["constr"].ToString(); SqlConnection conn = new SqlConnection(constr); string id = (((Label)row.FindControl("lblid")).Text).ToString(); string comments = (((TextBox)row.FindControl("txtcomments")).Text).ToString(); conn.Open(); SqlCommand CmdSql = new SqlCommand("Update leave set admin_comments='" + comments + "', granted='" + true + "' where id=" + id + " ", conn); CmdSql.ExecuteNonQuery(); GridView1.EditIndex = -1; conn.Close();
string constr = ConfigurationManager.ConnectionStrings["constr"].ToString();
if(ConfigurationManager.ConnectionStrings["constr"] != null && !String.IsNullOrEmpty(Convert.ToString(ConfigurationManager.ConnectionStrings["constr"])) ) { string constr = ConfigurationManager.ConnectionStrings["constr"].ToString(); }
string id = (((Label)row.FindControl("lblid")).Text).ToString();
.Text
.ToString()
Identity
id
SqlCommand CmdSql = new SqlCommand("Update leave set admin_comments='" + comments + "', granted='" + true + "' where id=" + id + " ", conn);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)