fetching of fields of a database in a profile page

Question

Dear Sir, I am making a profile page in Asp.net using C# where i am confused how to fetch data from my database which i created to store the detail of a student.i have taken different labels in which i want to show each respective fields of database in the respective labels(like first name,last name).

Rahul Prajapat · Answer

hello @sandeep try this SqlConnection con = new SqlConnection("data source= ;initial catalog= ;integrated security=true;"); DataTable dt1; SqlDataAdapter da; and call the method where you want to bind protected void FillStudentInfo() { string str = "select top 1 firstname,lastname,emailid,phoneNumber from Student where "; con.Open(); dt = new DataTable(); da = new SqlDataAdapter(str, con); da.Fill(dt); if (dt.Rows.Count != 0) { lblFname.Text = dt.Rows[0][0].ToString(); lblLname.Text = dt.Rows[0][1].ToString(); lblEmail.Text = dt.Rows[0][2].ToString(); lblPhone.Text = dt.Rows[0][3].ToString(); } con.Close() }

keerthi sai · Answer

hey i think it helpful to uu public void ProfileFill() { using (RegistrationEntity objRegistrationEntity = new RegistrationEntity()) { string username = Session["Name"].ToString(); objRegistrationEntity.UserName = username; using (MyProfileBAL objMyProfileBAL = new MyProfileBAL()) { DataTable dt = objMyProfileBAL.SelectUserNameBal(objRegistrationEntity); if (dt.Rows.Count > 0) { t xtFirstName.Text = dt.Rows[0]["FirstName"].ToString(); txtLastName.Text = dt.Rows[0]["LastName"].ToString(); txtxUserName.Text = dt.Rows[0]["UserName"].ToString(); txtEmail.Text = dt.Rows[0]["Email"].ToString(); txtPhone.Text = dt.Rows[0]["MobileNumber"].ToString(); txtMobile1.Text = dt.Rows[0]["Mobile1"].ToString(); } else { } } } }