Asp.net中利用GridView查询出结果后,点编辑所有的数据都出来了,只想要编辑查询结果怎么弄

weixin_44967738 weixin_44967738 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
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";
}
}
...全文

相关推荐

评论 1
收藏 已收藏
分享
返回顶部
weixin_44967738
.NET社区 62,272 成员 668,968 内容