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

[452 byte] By [whitegrs] at [2008-2-20]
# 1
Hi,

Check the SELECT Command of your tableadapter. See if the sql query it executes returns real data.

cheers,

Paul June A. Domag

PaulDomag at 2007-9-8 > top of Msdn Tech,Visual Studio Express Editions,Visual C# 2005 Express Edition...
# 2

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

Geeee at 2007-9-8 > top of Msdn Tech,Visual Studio Express Editions,Visual C# 2005 Express Edition...
# 3
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

Geeee at 2007-9-8 > top of Msdn Tech,Visual Studio Express Editions,Visual C# 2005 Express Edition...