62,046
社区成员
发帖
与我相关
我的任务
分享
if (Session["car"] == null)
{
string sql = "select * from SYS_PRODUCT_CFG where PRODUCT_TYPEID='" + Request.QueryString["gid"] + "'";
classDb db = new classDb();
DataTable dt = db.qurey(sql);//dt现在是个数据集
//=======自定义的表格========
DataTable mydt = new DataTable();
DataColumn dc1 = new DataColumn("gid", typeof(string));//编号列
mydt.Columns.Add(dc1);
DataColumn dc2 = new DataColumn("gname", typeof(string));//名称列
mydt.Columns.Add(dc2);
DataColumn dc3 = new DataColumn("gprice", typeof(string));//价格列
mydt.Columns.Add(dc3);
DataColumn dc4 = new DataColumn("gsdiscount", typeof(string));//合计价格
mydt.Columns.Add(dc4);
DataColumn dc5 = new DataColumn("gnum", typeof(string));//数量列
mydt.Columns.Add(dc5);
foreach (DataRow dr in dt.Rows)//循环dt表里面的所有列给自定义表格每一行赋值
{
DataRow mydr = mydt.NewRow();//创建新行
mydr["gid"] = dr["PRODUCT_TYPEID"].ToString();
mydr["gname"] = dr["PRO_NAME"].ToString();
mydr["gprice"] = dr["PRICE"].ToString();
mydr["gsdiscount"] = dr["PRICE"].ToString();
mydr["gnum"] = "1";
mydt.Rows.Add(mydr);
}
Session["car"] = mydt;//把买的商品存储到session中
this.GridView1.DataSource = mydt;
this.GridView1.DataBind();
}
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="gid" Font-Size="12px"
OnRowDataBound="GridView1_RowDataBound" OnRowDeleting="GridView1_RowDeleting"
OnRowUpdating="GridView1_RowUpdating" Width="496px" AllowPaging="True"
onpageindexchanging="GridView1_PageIndexChanging" PageSize="7">
<Columns>
<asp:TemplateField HeaderText="编号">
<ItemTemplate>
<asp:Label runat="server" ID="lbid" Text='<%# Bind("gid")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="gname" HeaderText="商品名" />
<asp:BoundField DataField="gprice" HeaderText="单价" />
<asp:TemplateField HeaderText="数量">
<ItemTemplate>
<asp:LinkButton ID="LinkButton2" runat="server" >-</asp:LinkButton>
<asp:TextBox ID="TextBox1" runat="server"
ontextchanged="textbox1_TextChanged" AutoPostBack="true"
Text='<%# Bind("gnum") %>' MaxLength="2" Width="25px"></asp:TextBox>
<asp:LinkButton ID="LinkButton3" runat="server" onclick="LinkButton3_Click">+</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="gsdiscount" HeaderText="小计" />
<asp:TemplateField ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False"
CommandName="Delete" OnClientClick="return confirm("确定要删除吗");"
Text="删除" ForeColor="#FF9966"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>