Hi I am very need an advice for this.
I am new to ASP.NET C# / VS2003
here is my sql command
SELECT tblStudentCourse.CourseID, tblStudents.StudentID, tblStudents.FirstName, tblStudents.SurName, tblUsers.UserID, tblUsers.Username
FROM (tblStudents INNER JOIN (tblCourses INNER JOIN tblStudentCourse ON tblCourses.CourseID = tblStudentCourse.CourseID) ON tblStudents.StudentID = tblStudentCourse.StudentID) INNER JOIN tblUsers ON tblStudents.StudentID = tblUsers.StudentID
where tblUsers.Username = @username;
so after login with the username how can I get the result of student's course information
now I try this but it still not work.
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
String @username;
@username = User.Identity.Name.ToString();
Response.Write(@username);
@username.Equals(this.oleDbDataAdapter1.SelectComm and.Parameters["@username"].Value.ToString());
this.DataGrid1.DataBind();
}
Please anyone know about this advice me it very urgent for my final study project.
Thank you