Need help adding a query to a datagridview

Hi,

Why don't you just use a stored procedure to deal with the select statement and use a data reader to read the results of a stored procedure?

You can do it something like this as an example

Public Function GetSelectResult(ByVal Param1 as string, ByVal Param2 as string) As Boolean

        Dim DR As SqlClient.SqlDataReader
        Dim Conn As New SqlClient.SqlConnection(<your connection string>)

        Dim Cmd As New SqlClient.SqlCommand("usp_GetSelectResult")

        Try
            If Conn.State <> ConnectionState.Open Then
                Conn.Open()
            End If

            Cmd.CommandType = CommandType.StoredProcedure
            Cmd.Connection = Conn
            Cmd.Parameters.AddWithValue("@Param1",Param1)
            Cmd.Parameters.AddWithValue("@Param2", Param2)

            DR = Cmd.ExecuteReader()

            While DR.Read()
                ''Read you data reader here.
            End While

            DR.Close()
         
            Return True
        Catch ex As Exception
            _ErrorDescription = "Error retrieving All Details: " & ex.Message & _
                " - " & ex.Source & " - " & ex.StackTrace
            Return False
        Finally
            If Conn.State = ConnectionState.Open Then
                Conn.Close()
            End If
        End Try

    End Function

The issue is that the end-user display choice and what's in place is the gridview.

Personally, I'd rather do it the old-fashioned way (without this data-bound MS creates), but it's what we've been told to use.

Oh OK.  You can then use Datatable.Select/DefaultView.RowFilter if this is the case.  Check this out.

http://programming.top54u.com/post/ASP-Net-DataTable-Select-Rows-using-DefaultView-RowFilter.aspx

http://www.dbtutorials.com/display/dataview-datatable-csharp.aspx

It looks to me like this is selecting rows already returned to the initial datagridview.

or actually just filtering what to show or not.

What I'm looking for is how to modify the select so that only the rows we want to see are returned from the database in the first place.

OK.  Check this out.  This might help.

http://forums.asp.net/p/1058769/1514593.aspx#1514593

http://forums.asp.net/p/1010607/1348581.aspx

well, now we're slipping over to gridviews, which are different.

Also one of these is just filtering data in the grid already created.

I think I've found what I was looking for http://msdn.microsoft.com/en-us/library/fbk67b6z.aspx.

Oh yeah.  Sorry.  It is DataGridView.  Windows....  I tend to mix those two from time to time.   :-)

That is good if you found what you are looking for.  Goodluck with your projects. :-)