Visual Studio 2008, C#, SQL Server 2005
Hello,
I'm haveing trouble figuring out how to send the current logged-in user's UserId to a SqlDataSource. Currently I'm using a SqlDataSource that's tied to a GridView, and I want to pull all reports that a user has submited. The reports come from a Reports table and have the submitting user's UserId stored in each entry. I would really like to be able to do the database accessing using the code-behind file or a Data Access Layer, but the current layer I have isn't working with the stored procedure I created and doesn't bind(?) properly to the GridView I created. Nothing shows up in the GridView after GridView.DataSource and DataBind() have exicuted.
My second question is in regards to pulling information from a table based on a column in the Reports table matching a column in the Projects table. The Projects Table has a ProjectID and ProjectName; Reports Table has a ReportID and ProjectID ...
Go to the complete details ...