datalist gridview编辑.删除多行
来源:互联网 发布:弗兮网络 编辑:程序博客网 时间:2024/05/14 16:05
cs部分:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class test_list : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
for (int i = 1; i <=GridView1.Columns.Count; i++)
{
DropDownList1.Items.Add(i.ToString());
}
}
}
protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
{
DataList1.EditItemIndex = e.Item.ItemIndex;
DataList1.DataBind();
}
protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
{
DataList1.EditItemIndex = -1;
DataList1.DataBind();
}
protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
{
int id = Convert.ToInt32(DataList1.DataKeys[e.Item.ItemIndex]);
string username = ((TextBox)e.Item.FindControl("TextBox1")).Text;
string pwd = ((TextBox)e.Item.FindControl("TextBox2")).Text;
if (DB.exesql("update login set username='"+username+"',userpwd='"+pwd+"' where id="+id) > 0)
{
// Response.Write("<script>alert('修改成功!');</script>");
DataList1.EditItemIndex = -1;
DataList1.DataBind();
}
}
protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
{
int id = Convert.ToInt32(e.Item.ItemIndex);
if(DB.exesql("delete from login where id="+id)>0)
{
DataList1.EditItemIndex = -1;
DataList1.DataBind();
}
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
int c = Convert.ToInt32(DropDownList1.SelectedValue)-1;
GridView1.Columns[c].Visible = false;
}
protected void Button2_Click(object sender, EventArgs e)
{
for (int i = 0; i < GridView1.Columns.Count;i++ )
{
GridView1.Columns[i].Visible = true;
}
}
protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
{
foreach( GridViewRow dr in GridView1.Rows )
{
CheckBox chk = (CheckBox)dr.Cells[3].FindControl("CheckBox2");
if (!chk.Checked)
{
chk.Checked = true;
}
else
{
chk.Checked = false;
}
}
}
protected void Button3_Click(object sender, EventArgs e)
{
foreach( GridViewRow gr in GridView1.Rows )
{
CheckBox chk = (CheckBox)gr.Cells[3].FindControl("CheckBox2");
if (chk.Checked)
{
int UserID = Convert.ToInt32(((HiddenField)gr.Cells[4].FindControl("HiddenField1")).Value);
DB.exesql("delete from ygb where yg_id=" + UserID);
GridView1.DataBind();
Response.Write("删除成功!");
}
}
}
}
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class test_list : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
for (int i = 1; i <=GridView1.Columns.Count; i++)
{
DropDownList1.Items.Add(i.ToString());
}
}
}
protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
{
DataList1.EditItemIndex = e.Item.ItemIndex;
DataList1.DataBind();
}
protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
{
DataList1.EditItemIndex = -1;
DataList1.DataBind();
}
protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
{
int id = Convert.ToInt32(DataList1.DataKeys[e.Item.ItemIndex]);
string username = ((TextBox)e.Item.FindControl("TextBox1")).Text;
string pwd = ((TextBox)e.Item.FindControl("TextBox2")).Text;
if (DB.exesql("update login set username='"+username+"',userpwd='"+pwd+"' where id="+id) > 0)
{
// Response.Write("<script>alert('修改成功!');</script>");
DataList1.EditItemIndex = -1;
DataList1.DataBind();
}
}
protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
{
int id = Convert.ToInt32(e.Item.ItemIndex);
if(DB.exesql("delete from login where id="+id)>0)
{
DataList1.EditItemIndex = -1;
DataList1.DataBind();
}
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
int c = Convert.ToInt32(DropDownList1.SelectedValue)-1;
GridView1.Columns[c].Visible = false;
}
protected void Button2_Click(object sender, EventArgs e)
{
for (int i = 0; i < GridView1.Columns.Count;i++ )
{
GridView1.Columns[i].Visible = true;
}
}
protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
{
foreach( GridViewRow dr in GridView1.Rows )
{
CheckBox chk = (CheckBox)dr.Cells[3].FindControl("CheckBox2");
if (!chk.Checked)
{
chk.Checked = true;
}
else
{
chk.Checked = false;
}
}
}
protected void Button3_Click(object sender, EventArgs e)
{
foreach( GridViewRow gr in GridView1.Rows )
{
CheckBox chk = (CheckBox)gr.Cells[3].FindControl("CheckBox2");
if (chk.Checked)
{
int UserID = Convert.ToInt32(((HiddenField)gr.Cells[4].FindControl("HiddenField1")).Value);
DB.exesql("delete from ygb where yg_id=" + UserID);
GridView1.DataBind();
Response.Write("删除成功!");
}
}
}
}
- datalist gridview编辑.删除多行
- Repeater\DataList\GridView实现分页,数据编辑与删除
- datalist删除多行记录
- 编辑多行 GridView
- gridview中关于删除和编辑行
- .net GridView数据行 删除,编辑
- GridView删除,编辑应用
- GridView自定义编辑、删除
- GridView自定义编辑、删除
- GridView 的编辑删除
- GridView更新,编辑,删除
- gridview 编辑删除:
- GridView编辑、删除
- GridView编辑删除操作
- GridView编辑、删除
- Gridview删除选中,编辑
- Gridview编辑,修改,删除
- DataList编辑、更新、取消、删除、分页
- 反编译c#的DLL工具,学习的好东西呀
- GridView中的超级链接
- GridView个小技巧
- MySQL3.23.15后版本设置数据同步(镜像数据库)
- 发现多媒体做起来真的很有意思
- datalist gridview编辑.删除多行
- [英语阅读]养猫能预防心脏病?
- MYSQL出错代码列表
- Mysql中limit的用法详解
- [英语阅读]英一提款机双倍吐钱 百人排队取款
- [转自Ownlinux.cn]Ubuntu官方提供离8.04正式版发布时间的WEB倒计时
- outOfMemoryError
- Poem by an African kid
- Mysql中limit的优化