fetching of fields of a database in a profile page

Sandeep Roy

11y873.NET

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).

2 Replies

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

Rahul Prajapat11y ago
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()

}
0
keerthi sai11y ago
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)
{
txtFirstName.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
{
}
}
}
}

0