How do I add an "as" clause to my select without a "differs from base query"

If my base query looks something like this:
select item_id, price, quantity from sales
But I want to have this happen instead...
select item_id, price, quantity, price*quantity as gross_sales from sales
How can I avoid the warning error "query differs from the base query" warning error at the BindingSource level since I don't seem to be able to change the base query and it won't let me add the modified query?
I'm using Visual Basic.Net 2005 beta 2 with SQL Express.

[642 byte] By [DanRhea] at [2007-12-16]

«« accessing custom tools options settings
»» Control's Leave event handler masks move to next control in tab order

# 1

Hello Dan,

To change the base query you can right-click the TableAdapter and select the option to Configure (configure modifies the base query, selecting Add Query adds a new query) additional queries 'should' return data in the same shape as the data table hooked to the TableAdapter.
You can also open the Dataset in the Dataset Designer and add a new TableAdapter with whatever query you want. (double-click the dataset in solution explorer (.xsd))
hope that helps...

SteveS_MS at 2007-9-9 >

.NET Development

.NET Framework Data Access and Storage

.NET Development Hot Topic

.NET Development New Topic

.NET Development

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Question about 'How do I add an "as" clause to my select without a "differs from base query"', No.56315,Posted by DanRhea

How do I add an "as" clause to my select without a "differs from base query"

.NET Development Hot Topic

.NET Development New Topic

.NET Development

Site Classified