ASPNETDB.MDF 提取 Membership.GetUser()
問 personal.mdf 中有否該用戶 ID 所編寫的記錄
該userid 是有資料
但空白一片 , 為何 ?
是否編寫錯誤 ???
web.config
<connectionStrings> <add name="CnString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=E:\personal.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> </connectionStrings>find.aspx.cs
protected void Page_Load(object sender, EventArgs e)
{ if (User.Identity.IsAuthenticated)
{
//顯示使用者資料
MembershipUser singleUser = Membership.GetUser(); string connString = WebConfigurationManager.ConnectionStrings["CnString"].ConnectionString;
SqlConnection conn = new SqlConnection(connString);
conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM [personal] where userid='<%#singleUser.UserName%>'", conn);
SqlDataReader dr = cmd.ExecuteReader(); GridView1.DataSource = dr;
GridView1.DataBind();
dr.Close(); dr = cmd.ExecuteReader();
DataGrid1.DataSource = dr;
DataGrid1.DataBind(); cmd.Dispose();
dr.Close();
dr.Dispose();
conn.Close();
conn.Dispose();
}
else
{
FormsAuthentication.RedirectToLoginPage();
}
find.aspx
<td style="width: 100px">
<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333">
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#E3EAEB" />
<EditRowStyle BackColor="#7C6F57" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</td>
<td style="width: 100px">
<asp:DataGrid ID="DataGrid1" runat="server" CellPadding="4" ForeColor="#333333">
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<AlternatingItemStyle BackColor="White" />
<ItemStyle BackColor="#FFFBD6" ForeColor="#333333" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
</asp:DataGrid></td>
問 personal.mdf 中有否該用戶 ID 所編寫的記錄
該userid 是有資料
但空白一片 , 為何 ?
是否編寫錯誤 ???
web.config
<connectionStrings> <add name="CnString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=E:\personal.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> </connectionStrings>find.aspx.cs
protected void Page_Load(object sender, EventArgs e)
{ if (User.Identity.IsAuthenticated)
{
//顯示使用者資料
MembershipUser singleUser = Membership.GetUser(); string connString = WebConfigurationManager.ConnectionStrings["CnString"].ConnectionString;
SqlConnection conn = new SqlConnection(connString);
conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM [personal] where userid='<%#singleUser.UserName%>'", conn);
SqlDataReader dr = cmd.ExecuteReader(); GridView1.DataSource = dr;
GridView1.DataBind();
dr.Close(); dr = cmd.ExecuteReader();
DataGrid1.DataSource = dr;
DataGrid1.DataBind(); cmd.Dispose();
dr.Close();
dr.Dispose();
conn.Close();
conn.Dispose();
}
else
{
FormsAuthentication.RedirectToLoginPage();
}
find.aspx
<td style="width: 100px">
<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333">
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#E3EAEB" />
<EditRowStyle BackColor="#7C6F57" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</td>
<td style="width: 100px">
<asp:DataGrid ID="DataGrid1" runat="server" CellPadding="4" ForeColor="#333333">
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<AlternatingItemStyle BackColor="White" />
<ItemStyle BackColor="#FFFBD6" ForeColor="#333333" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
</asp:DataGrid></td>
解决方案 »
- 求教用户权限划分
- 今天买了庖丁解牛,问下这本书里带的VS 2008安装光盘的版本和VS2005有什么区别?哪个好?
- ASP.NET有没有类似ASP的模版下载
- 请教一个简单的xsl的问题
- 为什么文件名长度被截断?
- 请教专家:如何让TD子元素与TD的HEIGH WIDTH 一模一样,边缘不留缝隙?
- 三楼楼长快出来!问你一个从你那下的OA系统调试问题。
- 请教asp.net 2.0
- 为什么创建或者打开web项目时一定要用自己的ip地址,用local就出错,搞不懂
- 请教现在有哪些支持dotnet的设计工具?哪些比较好?
- 这样的问题在SQL中如何实现?
- 在线等!!!急!!!!!!!asp.net中sql 操作Excel
明白了
真要買一本 C# , 一本 SQL , 一本 CSS 書學習 @_@