描述:对GridView分页,选择,增删改查等操作
绑定GridView,并且显示数据
public void BindGridView()
{
SqlConnection con = new SqlConnection("server=.;database=student;integrated security=true");
SqlDataAdapter da = new SqlDataAdapter("select *from stuInfo",con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.Caption = "学生信息表"; //显示表头
GridView1.DataKeyNames = new String[] {"sno"}; //定义主键
GridView1.DataBind();
}
显示详细信息
protected void GridView1_SelectedIndexChanging1(object sender, GridViewSelectEventArgs e)
{
string no = GridView1.DataKeys[e.NewSelectedIndex].Value.ToString();
SqlConnection con = new SqlConnection("server=.;database=student;integrated security=true");
SqlDataAdapter da = new SqlDataAdapter("select *from stuInfo where sno='" + no + "'", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView2.DataSource = ds;
GridView2.Caption = "学生详细信息表";
GridView2.DataBind();
}
实现分页功能
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
this.BindGridView();
}
实现编辑功能
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
this.BindGridView();
}
实现取消编辑功能
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
this.BindGridView();
}
实现更新数据功能
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
string no = GridView1.DataKeys[e.RowIndex].Value.ToString();
string name = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text;
SqlConnection con = new SqlConnection("server=.;database=student;integrated security=true");
con.Open();
SqlCommand cmd = new SqlCommand("update stuInfo set sname='" + name + "' where sno='" + no + "'",con);
cmd.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
this.BindGridView();
}
catch (Exception e1)
{
Response.Write(e1);
}
}
}
}