DataGridView Problem
Hi
I have a DataGridView on my form. On the form load event, I use the table adapter to fill the dataset.
tblEnquiryTableAdapter1.Fill(functionJunctionDataSet1.tblEnquiry);
The problem is that the data doesnt display in the datagrid. I have checked the fill query in the dataset and it too does not bring back any data but the query is correct and there is data in tblEnquiry.
What am I doing wrong ?
Thanks
Hi Paul
Here is the query copied from the "configure tabel adapter wizard"
SELECT EnquiryID, EnquiryDate, ClientID, VenueID, FunctionTypeID, FunctionDate, ActID1, ActID2
FROM tblEnquiry
The select command is correct as far as I can see. There is data in the table.
Thanks
Paul
I have 2 logins on this forum so hope didnt confuse things...
Anyway, I found the problem. I had made changes to the database and didnt reload the dataset xsd file. After I reloaded the modified enuiries table, the data came through fine.
Thanks