fakhravari
چهارشنبه 24 خرداد 1391, 12:15 عصر
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="ChkSelect" runat="server" />
</ItemTemplate>
</asp:TemplateField>
private void BindGrid()
{
using (SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["ConStr"].ConnectionString))
{
using (SqlCommand Cmd = new SqlCommand("FetchData", Con))
{
Cmd.CommandType = CommandType.StoredProcedure;
Con.Open();
SqlDataReader Dr = Cmd.ExecuteReader();
GridView1.DataSource = Dr;
GridView1.DataBind();
Dr.Close();
Con.Close();
}
}
}
private void RemoveData(string RowID)
{
using (SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["ConStr"].ConnectionString))
{
using (SqlCommand Cmd = new SqlCommand("RemoveData", Con))
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.AddWithValue("@MsgID", RowID);
Con.Open();
Cmd.ExecuteNonQuery();
Con.Close();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
}
protected void Delete_Click(object sender, EventArgs e)
{
string RowID = "";
foreach (GridViewRow myrow in GridView1.Rows)
{
CheckBox ChkSelect = (CheckBox)myrow.Cells[0].FindControl("ChkSelect");
if (ChkSelect.Checked)
RowID += GridView1.DataKeys[myrow.RowIndex].Value.ToString() + ",";
}
if (RowID.Length != 0)
RowID = RowID.Remove(RowID.Length - 1);
RemoveData(RowID);
BindGrid();
}