How can I do this with parameter?

[yui]

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?

It not work when I try this

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();
}

Thank you

[bnchd]

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?

It not work when I try this

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();
}

Thank you

hi yui


Well its not clear what u r trying to do at page load .
but better method is that u use a SqlCommand and datatable


string commandText = 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;

SqlCommand cmd = new SqlCommand(commandText,<connection string>)


cmd.CommandType = CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
DataTable dt = new DataTable();
adapter.Fill(dt);
adapter.Dispose();


Now u use this datatable to bind ur datagrid