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>