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";
}
}