Gridview的初步应用删除/更新/撤销/编辑/绑定/翻页

最新推荐文章于 2025-10-13 13:35:48 发布

原创最新推荐文章于 2025-10-13 13:35:48 发布 · 549 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#string #textbox #dataset #object #cmd #delete

asp.net 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一个简单的学生信息管理系统，包括从数据库加载数据到Gridview中显示、实现数据的增删改查等功能。系统使用C#语言编写，通过SqlConnection连接数据库，并利用SqlCommand执行SQL语句。

   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();

   }