I have a datagrid that needs to display records given by a Select statement with a WHERE clause that is passed in a given value by variable 'appID'. For some reason I've been unable to make it work any which way I tried.

As I'm not totally sure how to effectively pass a value in the context of a SQL Adapter to the DB, The last thing I tried was passing it to a variable and then to the SQL string. The compiler screams with the error:
Has anyone ever tried this?? I've looked around and most data bound to datagrids are usually simple queries, i.e., "Select * From Clients" with no filtering whatsoever.

Here's some code:



Sub BindGrid()
        Dim dsAppl As DataSet
        Dim conMeta As SqlConnection
        Dim dadAppl As SqlDataAdapter
        Dim whereClause As String = "WHERE Application_ID = '"&session("appID")&"' "

        dsAppl = New DataSet()
        conMeta = New SqlConnection( "Server='DOHSDBS96';trusted_connection=true;Databa se='METADATAv2'" )
        dadAppl = New SqlDataAdapter( "SELECT *, Q.Type AS QType, S.Type AS SType FROM A_Table A_T INNER JOIN Quality Q ON Q.Quality_ID=A_T.Quality_ID INNER JOIN Status S ON S.Status_ID=A_T.Status_ID" & whereClause & "ORDER BY & viewstate("sortField").ToString() & " " & viewstate("sortDirection").ToString(), conMeta )
        dadAppl.Fill( dsAppl,"A_Table" )
        Try
            AppDataGrid.DataSource = dsAppl
            AppDataGrid.Databind()
        Catch exc As Exception
            Response.Write(exc)
            AppDataGrid.CurrentPageIndex = 0
        End Try
        ShowStats
End Sub
 

Hey,

You know the where clause runs in with A_T.Status_ID, so it would appear as:

INNER JOIN Status S ON S.Status_ID=A_T.Status_IDWHERE Application_ID =

Put a space before the where clause.

Brian

I tried it with:

...Status_ID Where Application_ID = '55' ...

but got the same error:

Value of type 'String' cannot be converted to 'System.Data.SqlClient.SqlCommand'.

viewstate("sortDirection").ToString(), conMeta )

This may be the problem.

Take a look at this:
http://samples.gotdotnet.com/quickst...fdatagrid1.src

My advice would be to SELECT * FROM table_name and see if you are connecting, then add all the rest.

Hey,

Also noticed no ending quote after order by:
In addition, if you are still getting that error, try putting the entire SQL string into a sql command as such:
Brian