Adon Nicholls

How to retrieve card data and insert it into datagridview

Discussion created by Adon Nicholls on Jan 15, 2018
Latest reply on Jan 15, 2018 by Michael Dekoning

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)






                Dim Reader As SqlDataReader = CMD.ExecuteReader()





            End Using

        End Using

        Return DTVariables

   End Function



Any help would be appreciated.


Kind Regards,