It's been 19 years since I developed a windows form using VB. I've only done web development since. So I created a windows form and dragged a DataGridView control to my form. I then added 2 columns. I have a class library where I have a function that returns a datatable. This works as I use it on a web form. But when I run my windows form, I get the DataGridView with no data. Here is my code:
Imports System.Configuration
Imports OrdersClasses
Public Class Form1
Dim connStringNW As String = ConfigurationManager.ConnectionStrings("MRInw").
ConnectionString Private Sub Form1_Load(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles MyBase.Load
dgvOrders.DataSource = GetDataTable()
End Sub
Private Function GetDataTable() As DataTable
Dim dt As New DataTable(connStringNW)
dt = objOrder.GetOrderByStatusCode("I")
Return dt
End Function
End Class
This method works perfectly on my web form: objOrder.GetOrderByStatusCode("I") So what am I doing wrong? Why is my DataGridView not displaying my data?
Imports System.Configuration
Imports OrdersClasses
Public Class Form1
Dim connStringNW As String = ConfigurationManager.ConnectionStrings("MRInw").
ConnectionString Private Sub Form1_Load(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles MyBase.Load
dgvOrders.DataSource = GetDataTable()
End Sub
Private Function GetDataTable() As DataTable
Dim dt As New DataTable(connStringNW)
dt = objOrder.GetOrderByStatusCode("I")
Return dt
End Function
End Class
This method works perfectly on my web form: objOrder.GetOrderByStatusCode("I") So what am I doing wrong? Why is my DataGridView not displaying my data?