GridView的一个入门问题求解答

Question

在RowDataBound事件中..if (e.Row.RowType == DataControlRowType.DataRow) //判断是否数据行;{　　DataRowView drv = (DataRowView)e.Row.DataItem;　　string haveimg = drv["Hd_HaveImage"].ToString();　　string uid = drv["Hd_Id"].ToString();} 可以直接读取数据库中未绑定到列的字段. 或者可以用if (e.Row.RowType == DataControlRowType.DataRow) //判断是否数据行;{　　string haveimg = DataBinder.Eval(e.Row.DataItem , "Hd_HaveImage").ToString();}

Answer 1

GridView绑定数据显示商品详细信息
//GridView设置显示数据功能
 <asp:GridView ID="gvGoodsInfo" runat="server" CellPadding="4" 
                ForeColor="#333333" GridLines="None" Font-Size="9pt" 
                AutoGenerateColumns="False" AllowPaging="True" PageSize="8" 
                OnPageIndexChanging="gvGoodsInfo_PageIndexChanging" Width="450px">
                <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                <EditRowStyle BackColor="#999999" />
                <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                <PagerStyle BackColor="#CBCF7A" ForeColor="Black" HorizontalAlign="Right" />
                <HeaderStyle BackColor="#CBCF7A" Font-Bold="True" ForeColor="White" />
                <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                <Columns>
                    <asp:BoundField DataField="PicId" HeaderText="商品ID" />
                    <asp:BoundField DataField="PicType" HeaderText="所属类别" />
                    <asp:BoundField DataField="GoodsStock" HeaderText="库存量" />
                    <asp:BoundField DataField="PicName" HeaderText="商品名称" />
                    <asp:HyperLinkField HeaderText="详细信息" Text="详细信息" DataNavigateUrlFields="PicId" 
                        DataNavigateUrlFormatString="EditGInfo.aspx?GoodsID={0}" Target="mainframe" 
                        NavigateUrl="~/MemberManage/EditGInfo.aspx" >
                        <ControlStyle Font-Underline="False" ForeColor="Black" />
                        <ItemStyle Font-Underline="False" ForeColor="Black" />
                        <HeaderStyle Font-Underline="False" ForeColor="Black" />
                    </asp:HyperLinkField>
                </Columns>
            </asp:GridView>//codego.net/tags/11/1/
//cs页面绑定GridView控件加载数据
 SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
    protected void Page_Load(object sender, EventArgs e)
    {
        string sqlstr = "select * from tbPicture";               //创建执行查询操作的SQL语句
        sqlcon.Open();//打开数据库连接
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);//创建数据阅读器
        DataSet myds = new DataSet();                           //创建数据集
        myda.Fill(myds);                                        //填充数据集
        gvGoodsInfo.DataSource = myds;                          //设定数据源
        gvGoodsInfo.DataBind();                                 //绑定数据
        sqlcon.Close();                                         //关闭数据库连接
    }

Answer 2

DataItem as DataRowView
如果DataRowView不是DataItem 的子类 是不可以转的我现在很少用控件了，都mvc了
你可以搜索一下GridView 72般绝技