Asp.net中利用GridView查询出结果后,点编辑所有的数据都出来了,只想要编辑查询结果怎么弄
protected void Page_Load(object sender, EventArgs e)
{
GridView1.Visible = false;
if (!IsPostBack)
{
bindgrid();
}
}
string constr = ConfigurationManager.ConnectionStrings["hujixinxiConnectionString2"].ConnectionString;
private void bindgrid()
{
string sql = "select * from [information]";
SqlConnection con = new SqlConnection(constr);
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
con.Open();
da.Fill(ds, "information");
GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { "uname" };
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.Visible = true;
GridView1.EditIndex = e.NewEditIndex;
bindgrid();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.Visible = true;
GridView1.EditIndex = -1;
bindgrid();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridView1.Visible = true;
GridViewRow row = GridView1.Rows[e.RowIndex];
SqlConnection con = new SqlConnection(constr);
string sql = "update [information] set [name]='"
+ ((TextBox)(row.Cells[2].Controls[0])).Text.ToString().Trim() + "',[cname]='"
+ ((TextBox)(row.Cells[3].Controls[0])).Text.ToString().Trim() + "',[sex]='"
+ ((TextBox)(row.Cells[4].Controls[0])).Text.ToString().Trim() + "',[adress]='"
+ ((TextBox)(row.Cells[5].Controls[0])).Text.ToString().Trim() + "',[minzu]='"
+ ((TextBox)(row.Cells[6].Controls[0])).Text.ToString().Trim() + "',[jiguan]='"
+ ((TextBox)(row.Cells[7].Controls[0])).Text.ToString().Trim() + "',[birth]='"
+ ((TextBox)(row.Cells[8].Controls[0])).Text.ToString().Trim() + "',[tall]='"
+ ((TextBox)(row.Cells[10].Controls[0])).Text.ToString().Trim() + "',[xuexing]='"
+ ((TextBox)(row.Cells[11].Controls[0])).Text.ToString().Trim() + "',[study]='"
+ ((TextBox)(row.Cells[12].Controls[0])).Text.ToString().Trim() + "',[hunyin]='"
+ ((TextBox)(row.Cells[13].Controls[0])).Text.ToString().Trim() + "',[fuwu]='"
+ ((TextBox)(row.Cells[14].Controls[0])).Text.ToString().Trim() + "',[job]='"
+ ((TextBox)(row.Cells[15].Controls[0])).Text.ToString().Trim() + "',[qianlaicity]='"
+ ((TextBox)(row.Cells[16].Controls[0])).Text.ToString().Trim() + "',[qianlaiadress]='"
+ ((TextBox)(row.Cells[17].Controls[0])).Text.ToString().Trim() + "',[leixing]='"
+ ((TextBox)(row.Cells[18].Controls[0])).Text.ToString().Trim() + "',[person]='"
+ ((TextBox)(row.Cells[19].Controls[0])).Text.ToString().Trim() + "',[date]='"
+ ((TextBox)(row.Cells[20].Controls[0])).Text.ToString().Trim() + "' where [uname]='"
+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
SqlCommand com = new SqlCommand(sql, con);
con.Open();
com.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
bindgrid();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridView1.Visible = true;
GridViewRow row = GridView1.Rows[e.RowIndex];
SqlConnection con = new SqlConnection(constr);
string sql = "delete from [information] where [uname]='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
SqlCommand com = new SqlCommand(sql, con);
con.Open();
com.ExecuteNonQuery();
bindgrid();
}
protected void Button4_Click(object sender, EventArgs e)
{
GridView1.Visible = true;
if (DropDownList1.Text == "姓名")
{
string ConnStr =
System.Configuration.ConfigurationManager.ConnectionStrings["hujixinxiConnectionString2"].ToString();
using (SqlConnection conn = new SqlConnection(ConnStr))
{
string sqlstr = "select * from information where name like'%" + TextBox1.Text.Trim() + "%'";
SqlCommand cmd = new SqlCommand(sqlstr, conn);
conn.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
GridView1.HeaderRow.Cells[0].Text = "name";
GridView1.HeaderRow.Cells[1].Text = "cname";
GridView1.HeaderRow.Cells[2].Text = "sex";
GridView1.HeaderRow.Cells[3].Text = "adress";
GridView1.HeaderRow.Cells[4].Text = "minzu";
GridView1.HeaderRow.Cells[5].Text = "jiguan";
GridView1.HeaderRow.Cells[6].Text = "birth";
GridView1.HeaderRow.Cells[7].Text = "uname";
GridView1.HeaderRow.Cells[8].Text = "tall";
GridView1.HeaderRow.Cells[9].Text = "xuexing";
GridView1.HeaderRow.Cells[10].Text = "study";
GridView1.HeaderRow.Cells[11].Text = "hunyin";
GridView1.HeaderRow.Cells[12].Text = "fuwu";
GridView1.HeaderRow.Cells[13].Text = "job";
GridView1.HeaderRow.Cells[14].Text = "qianlaicity";
GridView1.HeaderRow.Cells[15].Text = "qianlaiadress";
GridView1.HeaderRow.Cells[16].Text = "leixing";
GridView1.HeaderRow.Cells[17].Text = "person";
GridView1.HeaderRow.Cells[18].Text = "date";
}
}
{
GridView1.Visible = false;
if (!IsPostBack)
{
bindgrid();
}
}
string constr = ConfigurationManager.ConnectionStrings["hujixinxiConnectionString2"].ConnectionString;
private void bindgrid()
{
string sql = "select * from [information]";
SqlConnection con = new SqlConnection(constr);
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
con.Open();
da.Fill(ds, "information");
GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { "uname" };
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.Visible = true;
GridView1.EditIndex = e.NewEditIndex;
bindgrid();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.Visible = true;
GridView1.EditIndex = -1;
bindgrid();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridView1.Visible = true;
GridViewRow row = GridView1.Rows[e.RowIndex];
SqlConnection con = new SqlConnection(constr);
string sql = "update [information] set [name]='"
+ ((TextBox)(row.Cells[2].Controls[0])).Text.ToString().Trim() + "',[cname]='"
+ ((TextBox)(row.Cells[3].Controls[0])).Text.ToString().Trim() + "',[sex]='"
+ ((TextBox)(row.Cells[4].Controls[0])).Text.ToString().Trim() + "',[adress]='"
+ ((TextBox)(row.Cells[5].Controls[0])).Text.ToString().Trim() + "',[minzu]='"
+ ((TextBox)(row.Cells[6].Controls[0])).Text.ToString().Trim() + "',[jiguan]='"
+ ((TextBox)(row.Cells[7].Controls[0])).Text.ToString().Trim() + "',[birth]='"
+ ((TextBox)(row.Cells[8].Controls[0])).Text.ToString().Trim() + "',[tall]='"
+ ((TextBox)(row.Cells[10].Controls[0])).Text.ToString().Trim() + "',[xuexing]='"
+ ((TextBox)(row.Cells[11].Controls[0])).Text.ToString().Trim() + "',[study]='"
+ ((TextBox)(row.Cells[12].Controls[0])).Text.ToString().Trim() + "',[hunyin]='"
+ ((TextBox)(row.Cells[13].Controls[0])).Text.ToString().Trim() + "',[fuwu]='"
+ ((TextBox)(row.Cells[14].Controls[0])).Text.ToString().Trim() + "',[job]='"
+ ((TextBox)(row.Cells[15].Controls[0])).Text.ToString().Trim() + "',[qianlaicity]='"
+ ((TextBox)(row.Cells[16].Controls[0])).Text.ToString().Trim() + "',[qianlaiadress]='"
+ ((TextBox)(row.Cells[17].Controls[0])).Text.ToString().Trim() + "',[leixing]='"
+ ((TextBox)(row.Cells[18].Controls[0])).Text.ToString().Trim() + "',[person]='"
+ ((TextBox)(row.Cells[19].Controls[0])).Text.ToString().Trim() + "',[date]='"
+ ((TextBox)(row.Cells[20].Controls[0])).Text.ToString().Trim() + "' where [uname]='"
+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
SqlCommand com = new SqlCommand(sql, con);
con.Open();
com.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
bindgrid();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridView1.Visible = true;
GridViewRow row = GridView1.Rows[e.RowIndex];
SqlConnection con = new SqlConnection(constr);
string sql = "delete from [information] where [uname]='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
SqlCommand com = new SqlCommand(sql, con);
con.Open();
com.ExecuteNonQuery();
bindgrid();
}
protected void Button4_Click(object sender, EventArgs e)
{
GridView1.Visible = true;
if (DropDownList1.Text == "姓名")
{
string ConnStr =
System.Configuration.ConfigurationManager.ConnectionStrings["hujixinxiConnectionString2"].ToString();
using (SqlConnection conn = new SqlConnection(ConnStr))
{
string sqlstr = "select * from information where name like'%" + TextBox1.Text.Trim() + "%'";
SqlCommand cmd = new SqlCommand(sqlstr, conn);
conn.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
GridView1.HeaderRow.Cells[0].Text = "name";
GridView1.HeaderRow.Cells[1].Text = "cname";
GridView1.HeaderRow.Cells[2].Text = "sex";
GridView1.HeaderRow.Cells[3].Text = "adress";
GridView1.HeaderRow.Cells[4].Text = "minzu";
GridView1.HeaderRow.Cells[5].Text = "jiguan";
GridView1.HeaderRow.Cells[6].Text = "birth";
GridView1.HeaderRow.Cells[7].Text = "uname";
GridView1.HeaderRow.Cells[8].Text = "tall";
GridView1.HeaderRow.Cells[9].Text = "xuexing";
GridView1.HeaderRow.Cells[10].Text = "study";
GridView1.HeaderRow.Cells[11].Text = "hunyin";
GridView1.HeaderRow.Cells[12].Text = "fuwu";
GridView1.HeaderRow.Cells[13].Text = "job";
GridView1.HeaderRow.Cells[14].Text = "qianlaicity";
GridView1.HeaderRow.Cells[15].Text = "qianlaiadress";
GridView1.HeaderRow.Cells[16].Text = "leixing";
GridView1.HeaderRow.Cells[17].Text = "person";
GridView1.HeaderRow.Cells[18].Text = "date";
}
}
...全文
相关推荐
Jsp GridView(代数据库)
GridView是ASP.NET中的一个控件,通常用于展示数据集合,如数据库表格,以网格形式呈现,具有排序、分页和编辑功能。
ASP.NET中GridView嵌套GridView层级数据展示实战
在构建复杂数据展示界面时,ASP.NET Web Forms平台中的GridView控件因其强大的数据绑定能力与灵活的模板机制,成为企业级应用中常用的数据呈现工具。尤其在处理主从(Master-Detail)结构数据场景下,通过在一个父级GridView的单元格中嵌套另一个子GridView,可以实现层级化、可展开的数据视图,极大提升信息组织效率和用户体验。
GridView和DropDownList结合
### GridView与DropDownList结合知识点详解#### 一、概述在Web开发中,尤其是在ASP.NET Web Forms中,经常需要处理动态生成的数据展示和编辑。
asp.net, c#,gridview对数据进行绑定,增加,查询,删除,修改,数据,
本文将深入探讨如何使用C#语言与ASP.NET配合,通过GridView实现数据的绑定、增加、查询、删除和修改功能。首先,数据绑定是GridView的核心功能。
ASP.NET GridView做增删改查操作
在Web应用程序开发中,GridView通常与数据库结合使用,提供用户友好的界面来处理数据。这篇教程将深入探讨如何利用ASP.NET GridView实现这些基本的数据操作。


