protected void btnView_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in GridLeaveApproved.Rows)
{
CheckBox ch = (CheckBox)row.FindControl("CheckBox1");
if (ch.Checked)
{
Label lblEid = (Label)row.FindControl("lblEmpId");
string eid = lblEid.Text;
cmd = new MySqlCommand("Select * from empleaves where EmpId=@eid ", conn);
cmd.Parameters.AddWithValue("@eid", eid);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "newleave");
GridLeavesView.DataSource = ds.Tables["newleave"];
GridLeavesView.DataBind();
}
}
GridLeavesView.Visible = true;
}
i want to check only one checkbox. i am trying to select two checkboxes show error message like(only select one checkbox) when after clicking View Button.
please help me friends..
What I have tried:
protected void btnView_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in GridLeaveApproved.Rows)
{
CheckBox ch = (CheckBox)row.FindControl("CheckBox1");
if (ch.Checked)
{
//Label lblleaveid = (Label)row.FindControl("lblLid");
//int lid = Convert.ToInt32(lblleaveid.Text);
//Label lbllid = (Label)row.FindControl("lblLId");
//int lid = Convert.ToInt32(lbllid.Text);
Label lblEid = (Label)row.FindControl("lblEmpId");
string eid = lblEid.Text;
cmd = new MySqlCommand("Select * from empleaves where EmpId=@eid ", conn);
cmd.Parameters.AddWithValue("@eid", eid);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "newleave");
GridLeavesView.DataSource = ds.Tables["newleave"];
GridLeavesView.DataBind();
}
}
GridLeavesView.Visible = true;
}