gridview_查看当前信息

1、goodsinfo.aspx的样子

 2、前台部分代码

<Columns>
                    <asp:BoundField DataField="GoodsID" HeaderText="商品ID" />
                    <asp:BoundField DataField="GoodsName" HeaderText="商品名称" />
                    <asp:HyperLinkField HeaderText="详细信息" Text="详细信息" DataNavigateUrlFields="GoodsID" 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>

3、后台代码

public partial class MemberManage_GoodsInfo : System.Web.UI.Page
{
    SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
    protected void Page_Load(object sender, EventArgs e)
    {
        string sqlstr = "select * from tb_GoodsInfo";
        sqlcon.Open();
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        myda.Fill(myds);
        gvGoodsInfo.DataSource = myds;
        gvGoodsInfo.DataBind();
        sqlcon.Close();
    }
    protected void gvGoodsInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvGoodsInfo.PageIndex = e.NewPageIndex;
        gvGoodsInfo.DataBind();
    }
    protected void btnSel_Click(object sender, EventArgs e)
    {

    }
}

3、editGinfo.aspx的后台代码

public partial class MemberManage_EditGInfo : System.Web.UI.Page
{
    SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            sqlconn.Open();
            string strid = Page.Request.QueryString["GoodsID"];
            string sqlstr = "select * from tb_GoodsInfo where GoodsID='" + strid + "'";
            SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlconn);
            DataSet myds = new DataSet();
            myda.Fill(myds, "tb_GoodsInfo");
            DataRowView mydrv = myds.Tables["tb_GoodsInfo"].DefaultView[0];
            txtGID.Text = Convert.ToString(mydrv.Row["GoodsID"]);
            txtGName.Text = Convert.ToString(mydrv.Row["GoodsName"]);
           
            txtGPrice.Text = Convert.ToString(mydrv.Row["GoodsPrice"]);
            txtGDate.Text = Convert.ToString(mydrv.Row["GoodsDate"]);
            txtGIntro.Text = Convert.ToString(mydrv.Row["GoodsIntroduce"])+"…";
            iGPhoto.ImageUrl = Convert.ToString(mydrv.Row["GoodsPhoto"]);
        }
    }
}