Gridview的问题 gridview 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Scid='id' ? 改成Scid='"+id+"' 你的ID都没传进去啊 对,这里有错。可以显示gridview,但里面没数据(数据库中检测是有的) 按照1楼说的你把string sqlstr = "SELECT * FROM shoppinglist WHERE Scid='id'";改成: string sqlstr = "SELECT * FROM shoppinglist WHERE Scid='“+id+”'";还是不好使么 对的string id = Session["username"].ToString(); string sqlstr = "SELECT * FROM shoppinglist WHERE Scid='"+id+"'"; string strCon = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlConnection Cn = new SqlConnection(strCon); Cn.Open(); SqlDataAdapter myda = new SqlDataAdapter(sqlstr, Cn); DataSet myds = new DataSet(); myda.Fill(myds, "购物车"); DataView view = myds.Tables["购物车"].DefaultView; GridView1.DataSource = view; GridView1.DataBind(); Cn.Close(); 前台是这样的<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" CellPadding="3" Font-Size="9pt" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Height="174px" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" Width="243px"> <FooterStyle BackColor="White" ForeColor="#ed1010" /> <Columns> <asp:BoundField HeaderText="用户名" ReadOnly="True" /> <asp:BoundField HeaderText="商品名称" /> <asp:BoundField HeaderText="购买数量" /> <asp:BoundField HeaderText="下单时间" /> </Columns> <RowStyle ForeColor="#000066" /> <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" /> <HeaderStyle BackColor="#ed1010" Font-Bold="True" ForeColor="White" /> </asp:GridView> 懂了,前台<asp:BoundField HeaderText="用户名" ReadOnly="True" />中少DataField="Scid" DataGridView 绑定 SQL2005 数据排序问题 提取网页正则。 C/S程序在线自动更新问题,谢谢求教! 请教了个问题。。有关网页的秘密~额~~高手来!!! 求助:c#属性和构造函数的区别 关于ajax执行服务器事件后回发激发客户端script求助 规则格网(GRID)的等值点连接 怎么在网页上动态显示数据库 请问一个简单的问题 当一个字段为空的时候显示指定的几个字,该如何写 关于多线程请求url解决方案 c#2010 链接oracle ,appconfig如何写,需要安装oracle客户端么?
Scid='"+id+"' 你的ID都没传进去啊
对,这里有错。可以显示gridview,但里面没数据(数据库中检测是有的)
改成: string sqlstr = "SELECT * FROM shoppinglist WHERE Scid='“+id+”'";
还是不好使么
对的string id = Session["username"].ToString();
string sqlstr = "SELECT * FROM shoppinglist WHERE Scid='"+id+"'";
string strCon = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection Cn = new SqlConnection(strCon);
Cn.Open();
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, Cn);
DataSet myds = new DataSet();
myda.Fill(myds, "购物车");
DataView view = myds.Tables["购物车"].DefaultView;
GridView1.DataSource = view;
GridView1.DataBind();
Cn.Close();
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" CellPadding="3" Font-Size="9pt" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Height="174px" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" Width="243px">
<FooterStyle BackColor="White" ForeColor="#ed1010" />
<Columns>
<asp:BoundField HeaderText="用户名" ReadOnly="True" />
<asp:BoundField HeaderText="商品名称" />
<asp:BoundField HeaderText="购买数量" />
<asp:BoundField HeaderText="下单时间" />
</Columns>
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<HeaderStyle BackColor="#ed1010" Font-Bold="True" ForeColor="White" />
</asp:GridView>