Windows Develop Bookmark and Share   
 index > Windows Forms Data Controls and Databinding > the scema returned by the new query differs from the base query
 

the scema returned by the new query differs from the base query

I have the datagridview of USERS table on the form. I add query to new column, and create scalar query for added column like this: 

SELECT     COUNT(*) AS Column1
FROM         vw_Reception
WHERE     (PH17 >= @PH17) AND (PH17 < @PH18) AND (WO15 = @WO07)


 and receive this error:

the scema returned by the new query differs from the base query

This query calculates records from a view named vw_reception, but there are no any componet like dataadapter or datagridview for this view on the form.

Mirage_sk  Wednesday, October 07, 2009 10:30 AM
Hi Mirage_sk,

Thanks for providing the sql script. Could you please provide more information or a code snippet about how you use this sql?
From my experience, the cause of the error you mentioned is that the select outputs are not the same. You need to check the returnd column name of the select sql.
This is a similar thread: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/0b6546e2-754b-4398-9e43-5a30545d13e0

Regards,
Aland Li
Please mark the replies as answers if they help and unmark if they don't. This can be beneficial to other community members reading the thread.
Aland Li  7 minutes ago

You can use google to search for other answers

Custom Search

More Threads

• Displaying multiple lines in a datagrid
• Changing DataBound values w/o Changing Focus
• DataGridView Databinding
• DatePicker Cell Disappearing
• How to close mdi child form...
• How to Bind DataTable Column to DataGridView Column
• Make A More Generic TableAdapter?
• How to add new row from dataGridView
• [OleDB, DataSet] How to insert new data into database
• datagridview rows editable or not