求助ASP.NEt

显示全部楼层 · 2021-1-27 06:26:12

求GridView手工绑定代码！
分 -->

千问 · 2021-1-27 06:26:12

这是GridView的页面代码

下面就是你绑定的代码
然后你从数据库中查询返回DataSet
DataSetds=查询返回的DataSet;
gvInfo.DataSource=ds;
gvInfo.DataBind();
这样就可以了

千问 · 2021-1-27 06:26:12

编辑功能
protectedvoidGridView1_RowEditing(objectsender,GridViewEditEventArgse)
...{
GridView1.EditIndex=e.NewEditIndex;
BindGrid();
}
更新功能
//更新设置了OnRowEditing="GridView1_RowEditing"。
protectedvoidGridView1_RowUpdating(objectsender,GridViewUpdateEventArgse)
{
intid;
stringxiaozhu;
//下面得到主建
id=int.Parse(GridView1.Rows[e.RowIndex].Cells[0].Text);
//下面得到更新的内容
fxiaozhu;=((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
SqlConnectioncnn=newSqlConnection("保密");
try
{
cnn.Open();
//这里写更新
SqlCommandcmd=newSqlCommand("保密")
cmd.ExecuteNonQuery();
}catch()
{
}
finally
{
cnn.Close();
}
GridView1.EditIndex=-1;
BindGrid();
}
删除功能
protectedvoidGridView1_RowDeleting(objectsender,GridViewDeleteEventArgse)
...{
intindex=e.RowIndex;
DataKeykey=GridView1.DataKeys[index];
intid=Convert.ToInt32(key.Value.ToString());
GridView1.EditIndex=-1;
BindGrid();
}
//为了实现每列都可以自动点击排序，可以设置allowsorting=true,然后设置OnSorting="GridView1_Sorting"，
protectedvoidGridView1_Sorting(objectsender,GridViewSortEventArgse)
...{
ViewState["sortexpression"]=e.SortExpression;
//设置viewsate来保存每次排序时的顺序
if(ViewState["sortdirection"]==null)
...{
ViewState["sortdirection"]="asc";
}
else
...{
if(ViewState["sortdirection"].ToString()=="asc")
...{
ViewState["sortdirection"]="desc";
}
else
...{
ViewState["sortdirection"]="asc";
}
}
BindGrid();
}
先给你写这几个功能吧