我想绑定我想要的两个字段,但是先绑定了字段,然后再把数据库里查询的字段全部绑定,不知道怎么修改,高手帮帮忙啊
后台代码
- C# code
using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.OracleClient;public partial class _Default : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { fillGridView(); } } //填充GridView protected void fillGridView() { DataSet ds = new DataSet(); ds = GetData(); GridView1.DataSource = ds; GridView1.DataBind(); getRefSet(ds); } //分页 protected void getRefSet(DataSet ds) { lblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页"; lblPageCount.Text = "共 " + GridView1.PageCount.ToString() + " 页"; lblRecordCount.Text = "总共 " + ds.Tables[0].Rows.Count.ToString() + " 条"; if (ds.Tables[0].Rows.Count == 0) { lnkbtnFirst.Visible = false; lnkbtnPre.Visible = false; lnkbtnNext.Visible = false; lnkbtnLast.Visible = false; lblCurrentIndex.Visible = false; lblPageCount.Visible = false; lblRecordCount.Visible = false; } else if (GridView1.PageCount == 1) { lnkbtnFirst.Visible = false; lnkbtnPre.Visible = false; lnkbtnNext.Visible = false; lnkbtnLast.Visible = false; } lnkbtnFirst.CommandArgument = "1"; lnkbtnPre.CommandArgument = (GridView1.PageIndex == 0 ? "1" : GridView1.PageIndex.ToString()); lnkbtnNext.CommandArgument = (GridView1.PageCount == 1 ? GridView1.PageCount.ToString() : (GridView1.PageIndex + 2).ToString()); lnkbtnLast.CommandArgument = GridView1.PageCount.ToString(); } //第几页 protected void lnkbtnJumpPage_Click(object sender, EventArgs e) { GridView1.PageIndex = int.Parse(txtJumpPage.Text) - 1; lblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页"; fillGridView(); GridView1.DataBind(); } protected void PagerButtonClick(object sender, EventArgs e) { GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandArgument) - 1; fillGridView(); GridView1.DataBind(); } // 转换SQL查询结果为DataSet private DataSet GetData() { OracleConnection conn = new OracleConnection("Data Source=wgyx;user=wgyx;password=wgyx;"); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; String strSql = "select id,fuid,the from sys_organ"; cmd.CommandText = strSql; cmd.CommandType = CommandType.Text; DataSet ds = new DataSet(); try { conn.Open(); OracleDataAdapter ad = new OracleDataAdapter(); ad.SelectCommand = cmd; ad.Fill(ds); } catch (Exception ex) { Response.Write("数据库错误,错误原因:" + ex.Message); Response.End(); } finally { conn.Close(); } return ds; }}
前台代码
- HTML code
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" > <AlternatingRowStyle BackColor="LightSteelBlue" /> <PagerSettings Visible="False" /> <Columns> <asp:TemplateField HeaderText="ID"> <ItemTemplate> <%# Eval("id"%> </ItemTemplate> <ItemStyle BorderColor="LightGray" BorderStyle="Double" BorderWidth="1px" Width="100px" /> </asp:TemplateField> <asp:TemplateField HeaderText="地名"> <ItemTemplate> <%# Eval("the")%> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView>