protected void button_departed_Click(object sender, EventArgs e) { GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent; int index = gvRow.RowIndex; String sap_id = GridView_gateCheck.Rows[index].Cells[1].Text; SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString); if (con.State != ConnectionState.Open) { con.Open(); } SqlCommand cmd = new SqlCommand("update leave set departed='True' where sap_id='" + sap_id + "'", con); Int32 i = cmd.ExecuteNonQuery(); con.Close(); if (i == 1) { Response.Write("Departed"); } SqlDataAdapter da = new SqlDataAdapter("select * from leave where departed='False' and leave_status=3", con); DataTable dt = new DataTable(); da.Fill(dt); GridView_gateCheck.DataSource = dt; GridView_gateCheck.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString); SqlDataAdapter da = new SqlDataAdapter("select sap_id,branch from leave where departed='False' and leave_status=3", con); DataTable dt = new DataTable(); da.Fill(dt); GridView_gateCheck.DataSource = dt; GridView_gateCheck.DataBind(); }