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(); //关闭数据库连接
}
