I cant get the datagrid to populate.
Any idea why it wouldnt populate? I get an error Datamember property 'getemployees' is not found on the data source.
I's using a stored procedure for this.
thanx in advance
ALTER PROCEDURE getEmployees
AS
SELECT EmployeeID, FirstName, LastName, HireDate
FROM Employees
ORDER BY LastName
RETURN
Public Class Employees
Private Sub Employees_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'load info
Try
Dim EmployeesData As New DataTier 'set data
Dim EmployeesDataSet As NorthwindDataSet 'tell it where to get data
EmployeesDataSet = EmployeesData.getEmployees() 'tell it to get data
Dim ABindingSource As New BindingSource 'make a binder
With ABindingSource
.DataSource = EmployeesDataSet
.DataMember = "getEmployees"
End With
DGVEmployees.DataSource = ABindingSource
Catch ex As Exception
MessageBox.Show(ex.Message) 'exception
End Try
End Sub
End Class
Public Class DataTier
'set variables
Private EmployeesDataSet As NorthwindDataSet
Private EmployeesTableAdapter As NorthwindDataSetTableAdapters.EmployeesTableAdapter
Public Function getEmployees() As NorthwindDataSet 'make data set
EmployeesDataSet = New NorthwindDataSet 'set variables
EmployeesTableAdapter = New NorthwindDataSetTableAdapters.EmployeesTableAdapter 'set adapter
EmployeesTableAdapter.Fill(EmployeesDataSet.Employees) 'fill the adapter
Return EmployeesDataSet 'return the data
End Function
End Class
Bookmarks