当前位置: 代码迷 >> ASP.NET >> 急GridView绑定数据库查询的数据,绑定的字段重复显示如何修改
  详细解决方案

急GridView绑定数据库查询的数据,绑定的字段重复显示如何修改

热度:8570   发布时间:2013-02-25 00:00:00.0
急!GridView绑定数据库查询的数据,绑定的字段重复显示怎么修改?
我想绑定我想要的两个字段,但是先绑定了字段,然后再把数据库里查询的字段全部绑定,不知道怎么修改,高手帮帮忙啊

后台代码
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>