gridview如此绑定? 数据绑定

来源：百度知道 编辑：UC知道 时间：2024/05/28 12:28:00
aspx.cs
public void Select_Op()
{
string Sqltm = " Select * from T_CA_Rec Where 1 = 1 ";
if (this.TxtUser.Text.Trim() != "")
{
Sqltm += "And loginname like '%" + this.TxtUser.Text.Trim() + "%'";
}
if (this.TxtNum.Text.Trim()!= "")
{
Sqltm += "And ca_ins_hits like '%" + this.TxtNum.Text.Trim() + "%'";
}
DataSet objDs = DB.GetCommandDataSet(Sqltm);
if (objDs != null)
{
int RowCount = objDs.Tables[0].Rows.Count;
// LB_Info.Text = "查询结果共" + RowCount.ToString() + "条";
//3.绑定数据
GridView1.DataSource = objDs.Tables[0];
GridView1.DataBind();
}
}
//////////////////////////////////////////////////////////

<asp:BoundField HeaderText="编号" DataField="数据库字段名"/>
<asp:BoundField HeaderText="用户名(登陆名)" DataField="数据库字段名"/>
<asp:BoundField HeaderText="最后申请时间" DataField="数据库字段名"/>
<asp:BoundField HeaderText="申请次数" DataField="数据库字段名"/>
<asp:BoundField HeaderText="最后申请IP" DataField="数据库字段名"/>

直接
GridView1.DataSource = objDs；
GridView1.DataBind();