GridView 绑定部分字段问题求解，怎么绑定数据库里的部分字段呢？

lxbgg 2012-09-05 10:41:35



  <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 

   OnRowDataBound="GridView1_RowDataBound">

     <AlternatingRowStyle BackColor="LightSteelBlue"/>

      <PagerSettings Visible="False" />

        <Columns>                   

          <asp:TemplateField HeaderText="标题">  

          <ItemTemplate>  

          <%#Eval("id")%>  

          </ItemTemplate>  

          </asp:TemplateField>  

          <asp:TemplateField HeaderText="内容">  

          <ItemTemplate>  

          <%#Eval("content")%>  

          </ItemTemplate>  

          </asp:TemplateField>  

         </Columns>

   </asp:GridView>

麻烦帮忙看一下，报错为“System.Data.DataRowView”不包含名为“id”的属性，我不知道该在后台加什么，是这个吗？GridView1.DataKeyNames = new string[] {"id" };写在哪里呢？



protected void fillGridView()// 填充GridView

    {

        //DataSet ds = new DataSet();

        //ds = GetCusData(whereSql);

        //GridView1.DataSource = ds;

        //GridView1.DataBind();

        //getRefSet(ds);



    }

    //分页设置

    protected void getRefSet(DataSet ds)

    {

        lblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页";

        lblPageCount.Text = "共 " + GridView1.PageCount.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;

        }

        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();



    }

    //鼠标事件

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

    {

        e.Row.Attributes["onmouseover"] = "ItemOver(this)";



    }

    public void Button1_Click(object sender, EventArgs e)

    {

        string whereSql = Request.Form["xm"];

        string strSql = "select  t.username,s.custid,s.name as  姓名 ,s.position,s.address as 地址 ,s.position,s.phone  as 电话 from sys_custm t,sys_cust s where s.name=" +"'"+ whereSql +"'";

        DataSet ds = new DataSet();

        try

        {

            ds = sqlHelper.getDataSet(strSql);



        }

        catch (Exception ex)

        {

            Response.Write("数据库错误，错误原因：" + ex.Message);

            Response.End();

        }



        GridView1.DataSource = ds;

        GridView1.DataBind();

        

    }