Hi guys! Long time no see!
I'm trying to get a datagrid to work, but although when I run it there is no error, nothing appears on the datagrid. Yet, there seems nothing wrong with my code:
SQL = "select * from upload " & _ "where field003 like 'P'+'%'+'" & PONo & "' " & _ "and field009 like 'Being received' order by field003" 'Set up connections Dim SQLCommand = New SqlCommand(SQL, conn) conn.Open() Dim da As SqlDataAdapter = New SqlDataAdapter(SQLCommand) Dim ds As New DataSet da.Fill(ds, SQL) 'Attach dataset to datagrid dgBlowOut.DataSource = da
Thank you for your help:)