how to display details from database into textbox?

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_id,username,password,designation,department,location,reportingto)
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?

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 username,designation,department,location,reportingto 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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
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 username,designation,department,location,reportingto 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.
0