111,076
社区成员
发帖
与我相关
我的任务
分享求助，C#GridView无法显示
后台
SqlConnection key = new SqlConnection (ConfigurationManager.ConnectionStrings["blogConnectionString"].ConnectionString);
key.Open ();
SqlDataAdapter username = new SqlDataAdapter ("select * from UserRegistry where name = '" + "张三" + "'and password = '" + "zhangsan" + "'", key);
DataSet user = new DataSet ();
username.Fill (user, "user");
key.Close ();
Session["user"] = user;
前台:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication1.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="470px">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:blogConnectionString %>" SelectCommand="SELECT * FROM [post] WHERE ([publisherID] = @publisherID)">
<SelectParameters>
<asp:SessionParameter Name="publisherID" SessionField="(DataSet)Sessoin.Tables["user"].Rows[0][0]" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:blogConnectionString %>" SelectCommand="SELECT * FROM [reply] WHERE ([publisherID] = @publisherID)">
<SelectParameters>
<asp:SessionParameter Name="publisherID" SessionField="(DataSet)Session.Tables["user"].Rows[0][2]" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
数据源绑定上了，测试查询也能查到，代码也没报错，各位大佬能解释一下么，本人是个菜鸡，虐的轻一点
...全文
请发表友善的回复…
发表回复
