Display logged in user details in DetailsView using C# in ASP.Net

Question

HiI need to display data in detailview on the basis of users logged in can anyone hlep me

zameer · Accepted Answer

JOYSON saysprotected void PageLoadobject sender EventArgs e    if thisPageUserIdentityIsAuthenticated            FormsAuthenticationRedirectToLoginPage        if thisIsPostBack            thisBindDetailsView     private void BindDetailsView    string constr  ConfigurationManagerConnectionStringsconstrConnectionString    using SqlConnection con  new SqlConnectionconstr             using SqlCommand cmd  new SqlCommandSELECT pan bankname branchcode bankaddress accounttype accountno ifsccode FROM tblmadmin                    using SqlDataAdapter sda  new SqlDataAdapter                            cmdConnection  con                sdaSelectCommand  cmd                using DataTable dt  new DataTable                                    sdaFilldt                    DetailsView1DataSource  dt                    DetailsView1DataBind                                         Please replace the above

dharmendr · Answer

Hi  JOYSONYou need to change the select query and pass the parameter as per your requirementSince you are passing email id you need to write the select query like belowusing SqlCommand cmd  new SqlCommand34SELECT pan bankname branchcode bankaddress accounttype accountno ifsccode FROM tblmadmin WHERE UserName  3934  userName  343934

Display logged in user details in DetailsView using C# in ASP.Net

Company

Explore

Follow us

Contact Us