Gridview的初步应用 删除/更新/撤销/编辑/绑定/翻页
来源:互联网 发布:微信积分宝源码 编辑:程序博客网 时间:2024/05/21 10:17
private SqlConnection gc() //数据库连接
{
string str = ConfigurationManager.AppSettings["cs"].ToString();
SqlConnection mycon = new SqlConnection(str);
return mycon;
}
protected void b()//绑定gridview
{
SqlConnection c=gc();
c.Open();
string str="select * from tb_StuInfo";
SqlDataAdapter sda = new SqlDataAdapter(str, c);
DataSet ds = new DataSet();
sda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { "stuID" };
GridView1.DataBind();
c.Close();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)//删除
{
string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
string str = "delete from tb_StuInfo where stuID=" + Convert.ToInt32(id);
SqlConnection c = gc();
c.Open();
SqlCommand cmd = new SqlCommand(str, c);
cmd.ExecuteNonQuery();
c.Close();
b();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) //翻页
{
GridView1.PageIndex = e.NewPageIndex;
b();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) //编辑
{
GridView1.EditIndex = e.NewEditIndex;
b();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) //更新
{
SqlConnection c = gc();
c.Open();
string n = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.Trim();
Label1.Text= GridView1.Rows[e.RowIndex].Cells[3].Text.ToString();
string s = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.Trim();
string h = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.Trim();
string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
string sql = "update tb_StuInfo set stuName='" + n + "',stuSex= '" + s + "',stuHobby= '" + h + "' where stuID="+Convert.ToInt32(id);
SqlCommand cmd = new SqlCommand(sql, c);
cmd.ExecuteNonQuery();
c.Close();
GridView1.EditIndex = -1;
b();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) //取消
{
GridView1.EditIndex = -1;
b();
}
{
string str = ConfigurationManager.AppSettings["cs"].ToString();
SqlConnection mycon = new SqlConnection(str);
return mycon;
}
protected void b()//绑定gridview
{
SqlConnection c=gc();
c.Open();
string str="select * from tb_StuInfo";
SqlDataAdapter sda = new SqlDataAdapter(str, c);
DataSet ds = new DataSet();
sda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { "stuID" };
GridView1.DataBind();
c.Close();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)//删除
{
string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
string str = "delete from tb_StuInfo where stuID=" + Convert.ToInt32(id);
SqlConnection c = gc();
c.Open();
SqlCommand cmd = new SqlCommand(str, c);
cmd.ExecuteNonQuery();
c.Close();
b();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) //翻页
{
GridView1.PageIndex = e.NewPageIndex;
b();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) //编辑
{
GridView1.EditIndex = e.NewEditIndex;
b();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) //更新
{
SqlConnection c = gc();
c.Open();
string n = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.Trim();
Label1.Text= GridView1.Rows[e.RowIndex].Cells[3].Text.ToString();
string s = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.Trim();
string h = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.Trim();
string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
string sql = "update tb_StuInfo set stuName='" + n + "',stuSex= '" + s + "',stuHobby= '" + h + "' where stuID="+Convert.ToInt32(id);
SqlCommand cmd = new SqlCommand(sql, c);
cmd.ExecuteNonQuery();
c.Close();
GridView1.EditIndex = -1;
b();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) //取消
{
GridView1.EditIndex = -1;
b();
}
- Gridview的初步应用 删除/更新/撤销/编辑/绑定/翻页
- GridView绑定,编辑,更新,取消,删除,排序
- GridView更新,编辑,删除
- gridview 编辑,删除,更新的用法
- GridView基本的编辑,更新,删除操作
- GridView基本的编辑,更新,删除操作
- GridView基本的编辑,更新,删除操作
- gridview 编辑,删除,更新的用法
- GridView控件的编辑、删除、更新、取消!
- gridview 编辑,删除,更新的用法
- gridview 编辑,删除,更新的用法
- GridView删除,编辑应用
- GridView应用实例(包括添加、删除、更新以及DropDownList的绑定)转
- GridView的绑定,编辑,删除功能 (非常棒)
- GridView 的编辑删除
- GridView自定义模板的编辑,更新,取消,删除
- gridview 编辑,删除,更新的用法(未测试)
- GridView基本的操作 编辑 更新 取消 删除
- FreeBSD中使用ftp命令,提示Connection reset by peer的一个原因
- 使用JTBC轻松构建多语言版网站(ASP版)
- Pamie模块详解 python操作ie浏览器
- 一个爬虫例子
- C++ Primer 学习笔记——第5章 表达式
- Gridview的初步应用 删除/更新/撤销/编辑/绑定/翻页
- jsp过滤器解决乱码
- minipackage CODE
- ERP学习 之 财务管理
- VSS 2005 配置
- 5岁的滢滢
- vbs的一些
- Freebsd下使用packages安装samba34以及samba无法启动的一个原因
- 纠结的 float与行框 --- 文字围绕浮动之谜