Need SQL string or SP

[tsp1lrk72]

Hello- The following code gives me the data I need, but now I need to get it into my VB.net code- can I call this as a SQL string right in the sub?

SELECT SUM(Quantity),
CASE Product
    WHEN 'FIR-UPPERS' THEN 'MBF' 
	WHEN 'Nantucket Beadboard' THEN 'Truckload'
	WHEN 'Plywood Treads and Risers' THEN 'Pallet'
	WHEN 'Poplar and Oak Boards' THEN 'UNITS' 
	WHEN 'EWC Shingles' THEN 'SQUARES' 
	WHEN 'Unfinished Oak Flooring' THEN 'SQ FT' 
	WHEN 'WRC Shingles' THEN 'CARTONS' 
  END
FROM tblPoolinfo
Group by Product

Or should it be a Stored Procedure and then called from the code, not sure of the best approach.

Thanks-

 

[tsp1lrk72]

The results will probably go into a datagrid...if possible

 

[RiverGuy]

Have you worked with ADO.Net before? I'm not sure if your question is a data access question or just a string building question. But, to build that string into your app, it is as simple as:

YourCommand.CommandText = "SELECT SUM(Quantity)," & controlchars.crlf
YourCommand.CommandText &= "CASE Product" & ControlChars.CrLf
'etc, etc

 

[tsp1lrk72]

Thanks I'll give it a shot... More of a string building question- I appreciate your assistance-