GridView的增删改查

GridView简单的增删改查，自己做了个小项目和大家分享，希望有所帮助

（PS：我也是刚学者，有好的学习方法大家一起学习哈~）

先来贴出本文代码运行的结果：

点击增加一行，第一行出现空格输入内容，点击确定增加，就可以将数据保存到数据库，并绑定到gridview中

点击编辑出现更新和取消，就可以直接在gridview上修改内容了

（PS：编号id是自动生成的，所以不可以修改，在这边让它成为只读的）

前端代码

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

Width="326px">

/>

/>

onrowdeleting="GridView1_RowDeleting"

onrowediting="GridView1_RowEditing"

Width="449px" onrowcancelingedit="GridView1_RowCancelingEdit"

onrowupdating="GridView1_RowUpdating" style="margin-right: 0px" >

onclick="Button4_Click" />

 

OnClick="btnAdd_Click" />

编号

内容

  

onclick="Button3_Click" style="height: 26px" />

AutoGenerateColumns="False">

后台代码

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

string connSql = @"server=(local);database=ContentDB;user id=sa;password=topcie";

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

Bind();

}

}

private void Bind()

{

string sql = "select * from ContentTable";

SqlConnection conn = new SqlConnection(connSql);

conn.Open();

SqlDataAdapter dr = new SqlDataAdapter(sql, conn);

DataSet ds = new DataSet();

dr.Fill(ds);

this.GridView1.DataSource = ds;

this.GridView1.DataBind();

if (conn.State == ConnectionState.Open)

{

conn.Close();

}

}

protected void Button1_Click(object sender, EventArgs e)

{

if (textBox1.Text.ToString().Trim() != "")

{

using (SqlConnection conn = new SqlConnection(connSql))

{

string sql = string.Format("insert into ContentTable values('{0}')", textBox1.Text);

using (SqlCommand comm = new SqlCommand(sql, conn))

{

try

{

conn.Open();

comm.ExecuteNonQuery();

Response.Write("输入成功！");

}

catch (SqlException ex)

{

throw ex;

}

}

}

}

else

{

Response.Write("输入不能为空！");

}

}

protected void Button2_Click(object sender, EventArgs e)

{

Bind();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

int id = int.Parse(GridView1.Rows[e.RowIndex].Cells[2].Text);

string sqlstr = string.Format("delete from ContentTable where textID ={0}", id);

SqlConnection conn = new SqlConnection(connSql);

SqlCommand cmd = new SqlCommand(sqlstr, conn);

conn.Open();

cmd.ExecuteNonQuery();

if (cmd.ExecuteNonQuery() == 0)

{

ClientScript.RegisterStartupScript(this.GetType(), "sa", "");

Bind();

}

else

{

ClientScript.RegisterStartupScript(this.GetType(), "sa", "");

}

conn.Close();

GridView1.EditIndex = -1;

this.Bind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex; //GridView编辑项索引等于单击行的索引

Bind();

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

Bind();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

SqlConnection conn = new SqlConnection(connSql);

int id = int.Parse(GridView1.Rows[e.RowIndex].Cells[2].Text);

string content = (GridView1.Rows[e.RowIndex].Cells[3].FindControl("lbContent") as TextBox).Text;

string sqlstr = "update ContentTable set textContent='" + content + "'where textID='" + id + "'";

SqlCommand cmd = new SqlCommand(sqlstr, conn);

conn.Open();

cmd.ExecuteNonQuery();

conn.Close();

this.GridView1.EditIndex = -1;

Response.Write("");

this.Bind();

}

protected void Button3_Click(object sender, EventArgs e)

{

SqlConnection conn = new SqlConnection(connSql);

conn.Open();

if(this.DropDownList1.Text=="编号")

{

SqlCommand comm=new SqlCommand();

DataSet ds=new DataSet();

SqlDataAdapter sd=new SqlDataAdapter( "select * from ContentTable where textID like'%" + this.TextBox2.Text.ToString().Trim() + "%'",conn);

sd.Fill(ds,"ContentTable");//把ContentTable表填充到数据集中

this.GridView2.DataSource=ds;

this.GridView2.DataBind();//将数据绑定到GridView控件中

}

else if(this.DropDownList1.Text=="内容")

{

SqlCommand comm=new SqlCommand();

DataSet ds=new DataSet();

SqlDataAdapter sd=new SqlDataAdapter( "select * from ContentTable where textContent like'%" + this.TextBox2.Text.ToString().Trim() + "%'",conn);

sd.Fill(ds,"ContentTable");//把ContentTable表填充到数据集中

this.GridView2.DataSource=ds;

this.GridView2.DataBind();//将数据绑定到GridView控件中

}

conn.Close();

}

protected void Button4_Click(object sender, EventArgs e)

{

DataTable dt = new DataTable();

dt = GetGrideviewData();

DataRow newRow = dt.NewRow();

dt.Rows.InsertAt(newRow, 0);

GridView1.DataSource = dt;

GridView1.DataBind();

//GridView1.ShowFooter = true;

//Bind();

}

private DataTable GetGrideviewData()

{

DataTable dt = new DataTable();

dt.Columns.Add(new DataColumn("textID"));

dt.Columns.Add(new DataColumn("textContent"));

foreach (GridViewRow row in GridView1.Rows)

{

DataRow sourseRow = dt.NewRow();

sourseRow["textID"] = row.Cells[2].Text;

sourseRow["textContent"] = ((TextBox)row.Cells[3].FindControl("lbcontent")).Text;

//sourseRow["textContent"] = (GridView1.FooterRow.FindControl("txtcontent") as TextBox).Text;

dt.Rows.Add(sourseRow);

}

return dt;

}

//添加记录

protected void btnAdd_Click(object sender, EventArgs e)

{

string content = (GridView1.Rows[0].Cells[3].FindControl("lbContent") as TextBox).Text; //(GridView1.FooterRow.FindControl("txtcontent") as TextBox).Text;//注意变量的取名

using (SqlConnection conn = new SqlConnection(connSql))

{

string sql = string.Format("insert into ContentTable(textContent) values('" + content + "')");

using (SqlCommand comm = new SqlCommand(sql, conn))

{

try

{

conn.Open();

comm.ExecuteNonQuery();

// Response.Write("");

Bind();

}

catch (SqlException ex)

{

throw ex;

}

}

}

// GridView1.ShowFooter = false;

}

//取消

protected void btnCancel_Click(object sender, EventArgs e) {

GridView1.ShowFooter = false;

Bind();

// Response.Write("");

}

}