嗯,搞定了,不过有出现一个新问题,就是查询之后,编辑功能不能正确实现,就是查询之后,我点其中一项的编辑按钮,出来的编辑框所在行不是我点的那个,这样的如何解决?谢谢大神
我的后台代码如下:
usingSystem;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingSystem.Collections;
usingSystem.Configuration;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Web.UI.HtmlControls;
publicpartialclass_Default:System.Web.UI.Page
{
protectedvoidPage_Load(objectsender,EventArgse)
{
if(!IsPostBack)
{
bind();
}
}
publicvoidbind()
{
stringsqlstr="select*fromrs_user";
stringstrCon="Server=WIN-JNVKFSPA4HB\\MYSERVER;Database=User;Trusted_Connection=True";
SqlConnectionsqlcon=newSqlConnection(strCon);
SqlDataAdaptermyda=newSqlDataAdapter(sqlstr,sqlcon);
DataSetmyds=newDataSet();
sqlcon.Open();
myda.Fill(myds,"rs_user");
GridView1.DataSource=myds;
GridView1.DataKeyNames=newstring[]{"id"};
GridView1.DataBind();
sqlcon.Close();
}
protectedvoidGridView1_SelectedIndexChanged(objectsender,EventArgse)
{
}
protectedvoidGridView1_RowEditing(objectsender,GridViewEditEventArgse)
{
GridView1.EditIndex=e.NewEditIndex;
bind();
}
protectedvoidGridView1_RowUpdating(objectsender,GridViewUpdateEventArgse)
{
stringstrCon="Server=WIN-JNVKFSPA4HB\\MYSERVER;Database=User;Trusted_Connection=True";
SqlConnectionsqlcon=newSqlConnection(strCon);
stringsqlstr="updaters_usersetrealname='"
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim()+"',sex='"
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim()+"',age='"
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim()+"',data_name='"
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()+"',position='"
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim()+"',rztime='"
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim()+"',mobile='"
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim()+"',address='"
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[7].Controls[0])).Text.ToString().Trim()+"'whereid='"
+GridView1.DataKeys[e.RowIndex].Value.ToString()+"'";
SqlCommandsqlcom=newSqlCommand(sqlstr,sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
GridView1.EditIndex=-1;
bind();
}
protectedvoidGridView1_RowCancelingEdit(objectsender,GridViewCancelEditEventArgse)
{
GridView1.EditIndex=-1;
bind();
}
protectedvoidButton1_Click(objectsender,EventArgse)
{
stringsqlstr="select*fromrs_userwheresex='"+TextBox1.Text+"'";
stringstrCon="Server=WIN-JNVKFSPA4HB\\MYSERVER;Database=User;Trusted_Connection=True";
SqlConnectionsqlcon=newSqlConnection(strCon);
SqlCommandsqlcom=newSqlCommand(sqlstr,sqlcon);
SqlDataAdaptermyda=newSqlDataAdapter(sqlstr,sqlcon);
DataSetmyds=newDataSet();
sqlcon.Open();
myda.Fill(myds,"myda");
GridView1.DataSource=myds;
GridView1.DataKeyNames=newstring[]{"id"};
GridView1.DataBind();
sqlcon.Close();
TextBox2.Text="";
} |