Database

Must declare the variable '@TheYear'

SELECT o.customerid, od.orderid, SUM(od.quantity*od.unitprice) AS price 
    FROM Orders o, [Order Details] od
    WHERE Year(o.orderdate) = @TheYear AND od.orderid=o.orderid
    GROUP BY o.customerid, od.orderid
    ORDER BY o.customerid

DECLARE @TheYear int
SET @TheYear = 1998

SELECT 
  CASE GROUPING(o.customerid) WHEN 0 
THEN o.customerid ELSE '(Total)' END AS MyCustomerID, 
  CASE GROUPING(od.orderid) WHEN 0 
THEN od.orderid ELSE -1 END AS MyOrderID, 
  SUM(od.quantity*od.unitprice) AS price
FROM Orders o, [Order Details] od
WHERE Year(orderdate) = @TheYear AND od.orderid=o.orderid
GROUP BY o.customerid, od.orderid WITH ROLLUP
ORDER BY o.customerid, price

<br />
Dim cn As OdbcConnection<br />
<br />
cn = New OdbcConnection<br />
<br />
cn.ConnectionString = "DSN=MyDSN" _<br />
           & "; uid=MyUID; pwd=MyPwd; Pooling=False"<br />
<br />
cn.Open()<br />
cn.Close()<br />

<br />
Dim cn As ADODB.Connection<br />
<br />
Set cn = New ADODB.Connection<br />
<br />
cn.ConnectionString = "DSN=MyDSN" _<br />
           & "; uid=MyUID; pwd=MyPwd;OLE DB Services=-2"<br />
<br />
cn.Open<br />
cn.Close<br />
<br />
set cn = Nothing<br />
<br />

<br />
if(dsOrdersDetiles1.HasChanges()==true)<br />
               {<br />
<br />
<br />
                    AdOrdersDetiles.Update(dsOrdersDetiles1.Tables[0]); //only the data in the grid is update but i  need the OrderId to be update in the same row .<br />
               <br />
                    <br />
               }<br />