Hi All,

I am currently trying to create a tool that will be used to search through our Non-Conformance Report cards , take the data such as state and the card number and put it into a datagridview that I have created. I have managed to get it to look at the databases in the vault such as variables but don't know how to get it to pick up tangible data and put them into the data grid created.

The code I've got so far for it is:

Private Sub DataGridView1_CellContentClick(sender As Object, e As DataGridViewCellEventArgs) Handles NCRList.CellContentClick

        NCRList.DataSource = NonConformanceList()

    End Sub

    Private Function NonConformanceList() As DataTable

        Dim DTVariables As New DataTable

        Dim ConnString As String = ConfigurationManager.ConnectionStrings("NCR_Tracker.My.MySettings.Rotron_Live_VaultConnectionString2").ConnectionString

        Using Conn As New SqlConnection(ConnString)

            Using CMD As New SqlCommand("Select * From dbo.Variable", Conn)

                Conn.Open()

                Dim Reader As SqlDataReader = CMD.ExecuteReader()

                DTVariables.Load(Reader)

            End Using

        End Using

        Return DTVariables

   End Function

Any help would be appreciated.

Kind Regards,

Adz