J
John
Hi
I have the following sql for my dataadapter;
SELECT ID, Company, Status
FROM Companies
WHERE Status = @Status
I fill the dataadapter as
Me.CompanyTableAdapter.Fill(Me.MyDataSet.Companies, "Current") and it works
great. The problem is how do I view all Companies and not just the current
ones, when I need to? What changes do I need to make to the SQL and the fill
statement?
Thanks
Regards
I have the following sql for my dataadapter;
SELECT ID, Company, Status
FROM Companies
WHERE Status = @Status
I fill the dataadapter as
Me.CompanyTableAdapter.Fill(Me.MyDataSet.Companies, "Current") and it works
great. The problem is how do I view all Companies and not just the current
ones, when I need to? What changes do I need to make to the SQL and the fill
statement?
Thanks
Regards