Hi,
I am fairly new to vb.net but making progress...
I am using Visual Studio 2013 to create VB.net project. I have used the on GUI data sources to get data onto my form but the TableAdapter.Fill is retrieving all rows rather than just the one I want.
Basically Mainform calls SelectEmployeeForm which has a datatable array where the required emp is selected. In the Employee table there is a primary key called ID which I am logging for the selected employee row in a public variable called SelectedEmployeeID
(I am detailing this as I found...
Dim customersRow As NorthwindDataSet.CustomersRow
customersRow = NorthwindDataSet1.Customers.FindByCustomerID("ALFKI")
... on a MSDN page and thought this might be a solution as I have the ID value but could not get it to work. Once I had my customersRow I did not know how to get its data onto my form without doing a series of me.field = statements for each form field, which seemed stupid.
Basically on Mainform I have the autocreated line:
Me.TrainingEmployeesTableAdapter.Fill(Me.TrainingDBDataSet.Employees)
Where this fills my DataSet with all rows I only want the particular one I have the ID for.
Could someone please tell me how I can just load the required row into the me dataset.
I hope that made sense.
Many thanks,
Paul.
I am fairly new to vb.net but making progress...
I am using Visual Studio 2013 to create VB.net project. I have used the on GUI data sources to get data onto my form but the TableAdapter.Fill is retrieving all rows rather than just the one I want.
Basically Mainform calls SelectEmployeeForm which has a datatable array where the required emp is selected. In the Employee table there is a primary key called ID which I am logging for the selected employee row in a public variable called SelectedEmployeeID
(I am detailing this as I found...
Dim customersRow As NorthwindDataSet.CustomersRow
customersRow = NorthwindDataSet1.Customers.FindByCustomerID("ALFKI")
... on a MSDN page and thought this might be a solution as I have the ID value but could not get it to work. Once I had my customersRow I did not know how to get its data onto my form without doing a series of me.field = statements for each form field, which seemed stupid.
Basically on Mainform I have the autocreated line:
Me.TrainingEmployeesTableAdapter.Fill(Me.TrainingDBDataSet.Employees)
Where this fills my DataSet with all rows I only want the particular one I have the ID for.
Could someone please tell me how I can just load the required row into the me dataset.
I hope that made sense.
Many thanks,
Paul.