Passing selected value to sql serverto retireve values using datagrids
Posted on 2005-04-09
i am having some trouble passing a value selected from a datagrid to a sql statement which then retrieves data and displays it into a datagrid.
basically, i want to get the module selected from one datagrid, then query that with the database to select all those documents associated with that module id and display them in a datagrid.
Here is my sqlquery:
sqlquery = "SELECT Document_ID, Document_Title, Module_ID, Submission_Date FROM TblDocuments INNER JOIN TblModule ON TblDocuments.Module_ID = TblModule.Module_ID = WHERE TblModule.Module_ID = " & Request.QueryString("Module_ID")
and this is what i put in the datagrid URL format string: