VS2005 Gridview操作
//编辑
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
this.GridView1.EditIndex = e.NewEditIndex;
dataBind();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
this.GridView1.EditIndex = e.NewEditIndex;
dataBind();
}
//取消
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
this.GridView1.EditIndex = -1;
dataBind();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
this.GridView1.EditIndex = -1;
dataBind();
}
//更新
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = this.GridView1.Rows[e.RowIndex];
TextBox tb = (TextBox)row.Cells[1].Controls[0];
if (tb.Text == "")
{
com.ShowAlert("新闻类别不能为空!");
}
else
{
if (mtDs.UpdateNewsClass(tb.Text, Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString())) > 0)
{
//com.ShowAlert("更新成功!");
this.GridView1.EditIndex = -1;
dataBind();
}
else
{
com.ShowAlert("更新失败!");
}
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = this.GridView1.Rows[e.RowIndex];
TextBox tb = (TextBox)row.Cells[1].Controls[0];
if (tb.Text == "")
{
com.ShowAlert("新闻类别不能为空!");
}
else
{
if (mtDs.UpdateNewsClass(tb.Text, Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString())) > 0)
{
//com.ShowAlert("更新成功!");
this.GridView1.EditIndex = -1;
dataBind();
}
else
{
com.ShowAlert("更新失败!");
}
}
}
//删除
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strsql;
//int i = this.GridView1.EditIndex;
int id = (int)GridView1.DataKeys[e.RowIndex].Value;
//Label1.Text = i.ToString();
//string id = ((TextBox)(GridView1.Rows[i].Cells[0].Controls[0])).Text.ToString();
strsql = string.Format("delete * from bigclassname where bigclassnameid=" + id + "");
if (DBFun.ExecuteUpdate(strsql))
{
Response.Write("<script>alert('删除成功!');</script>");
Response.Redirect("news_class.aspx");
}
}
checkBox的全选:
if (btnSelect.Text == "全 选")
{
foreach (GridViewRow row in this.GridView1.Rows)
{
CheckBox cb = (CheckBox)row.FindControl("chkSelect");
cb.Checked = true;
}
this.btnSelect.Text = "全 消";
}
else if (btnSelect.Text == "全 消")
{
foreach (GridViewRow row in this.GridView1.Rows)
{
CheckBox cb =(CheckBox)row.FindControl("chkSelect");
cb.Checked = false;
}
this.btnSelect.Text = "全 选";
}
{
foreach (GridViewRow row in this.GridView1.Rows)
{
CheckBox cb = (CheckBox)row.FindControl("chkSelect");
cb.Checked = true;
}
this.btnSelect.Text = "全 消";
}
else if (btnSelect.Text == "全 消")
{
foreach (GridViewRow row in this.GridView1.Rows)
{
CheckBox cb =(CheckBox)row.FindControl("chkSelect");
cb.Checked = false;
}
this.btnSelect.Text = "全 选";
}
批量删除:
int a = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("chkSelect");
if (cb.Checked)
{
int > try
{
if (mtDs.DeleteNewsClass(id) > 0)
{
a = 1;
}
else
{
a = 2;
}
}
catch
{
a = 2;
}
}
}
if (a == 1)
{
com.ShowAlert("删除成功!");
}
if (a == 2)
{
com.ShowAlert("删除失败!");
dataBind();
}
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("chkSelect");
if (cb.Checked)
{
int > try
{
if (mtDs.DeleteNewsClass(id) > 0)
{
a = 1;
}
else
{
a = 2;
}
}
catch
{
a = 2;
}
}
}
if (a == 1)
{
com.ShowAlert("删除成功!");
}
if (a == 2)
{
com.ShowAlert("删除失败!");
dataBind();
}