<
Script runat="server"> Dim u_name As String = Me.User.Identity.Name Script><asp:AccessDataSource ID = "AccessDataSource1" runat="server" DataFile="C:\Documents and Settings\Charlie\My Documents\Visual Studio 2005\Projects\Student_Database\Enrollment_DB.mdb" SelectCommand="SELECT [StudentID], [SSN], [FirstName], [LastName], [Address], [Major], [Student Type] AS Student_Type, [Student Status] AS Student_Status, [Date of Birth] AS Date_of_Birth, [GPA] FROM [Students] WHERE ([xUserName] = @u_name)"> <SelectParameters>
<asp:Parameter Name="u_name" Type="String" />
SelectParameters> asp:AccessDataSource>
nikshuklaPosted Nov 6, 2006, 10:36 AM
Regards,