how to display details from database into textbox?

Question

Hai Friends I ve the table like create table users ( user_id varchar(10) username varchar(10) password varchar(10) designation varchar(10) department varchar(10) location varchar(10) reportingto varchar(10) ) insert into users(user_idusernamepassworddesignationdepartmentlocationreportingto) value('0010''Ram''Ram@123''TraineeSalesMan''Marketing''Delhi''00001) like Trainees reporting =>salesman in my login.aspx page ll use username & password to make login. after the login page redirects to empdetails.aspx now my requirements is 1) welcome+username right corner (from here the details ll display from database) 2)name of employee = textbox 3)designation =textbox 4)department =textbox 5)location = textbox 6)reportingto=textbox(0001 that related code name ll display on that textbox) how to make a code?

Iftikar Hussain · Answer

Hi After you succesfully login store the userid in Session variable as shown below Session[UserId]=userid; Then in empdetails.aspx call the below method from Page_load event private void GetData() { string userName = ; string designation = ; string department = ; string location = ; string reportingto = ; var userId=Session[UserId]; SqlConnection conn = new SqlConnection(@Data Source=SQLEXPRESS;Initial Catalog=Emp;Integrated Security=SSPI;); conn.Open(); SqlCommand cmd = new SqlCommand(select usernamedesignationdepartmentlocationreportingto from users where user_id=@userid conn); cmd.Parameters.AddWithValue(@userid userId); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { userName = dr[username].ToString(); designation = dr[designation].ToString(); department = dr[department].ToString(); location = dr[location].ToString(); reportingto = dr[reportingto].ToString(); } } conn.Close(); Lbl1.Text = Welcome  + userName; TxtBxEmpName.Text = userName; TxtBxdesignation.Text = designation; TxtBxdepartment.Text = department; TxtBxlocation.Text = location; TxtBxreportingto.Text = reportingto; } Regards Iftikar Remember to click Mark as Answer on the post if it helps you.