Database

myListBox.DataTextField = mds.TheTable.TextColumn.ColumnName;
myListBox.DataValueField = mds.TheTable.IDColumn.ColumnName;

DataSet1 o = new DataSet1();
MessageBox.Show( o.Staging.DescriptionColumn.ColumnName );

Bruce Duncan, CP#9088, CPUA 0xA1EE, Sonork 100.10030
Blackadder: Baldrick, have you no idea what irony is?
Baldrick: Yeah, it's like goldy and bronzy only it's made of iron.

Technically speaking the dictionary would define Visual Basic users as programmers.
But here again, a very generalized, liberal definition is being employed and it's wrong
- just plain wrong - Tom Archer 5/12/02

Bruce Duncan, CP#9088, CPUA 0xA1EE, Sonork 100.10030
Blackadder: Baldrick, have you no idea what irony is?
Baldrick: Yeah, it's like goldy and bronzy only it's made of iron.

//Construct datatable with schema of mytable ...<br />
OleDbCommand comm = new OleDbCommand("mytable", conn) ;<br />
comm.CommandType = CommandType.TableDirect ;<br />
OleDbDataReader reader = comm.ExecuteReader(CommandBehaviour.SchemaOnly) ;<br />
DataTable dt = reader.GetSchemaTable() ;<br />
reader.Close() ;

SELECT
    DateRented,
    COUNT(1) As TotalRentals,
    SUM(DVD) As DVDRentals
 
FROM
(
    SELECT
        CAST(
            CAST(Year(DateRented) As varchar(4))
            + '/' + CAST(Month(DateRented) As varchar(2))
            + '/' + CAST(Day(DateRented) As varchar(2))
        As datetime) As DateRented,
        
        CASE
            WHEN RentalType = 'DVD' THEN 1
            ELSE 0
        END As DVD
        
    FROM
        Rentals
        
) As R
 
GROUP BY
    DateRented
ORDER BY
    DateRented

select trunc(DateRented) DateRented,<br />
  count(*) TotalRentals,<br />
  sum(decode(RentalType, 'VHS', 1, 0)) VHSRentals,<br />
  sum(decode(RentalType, 'DVD', 1, 0)) DVDRentals,<br />
from Rentals<br />
group by trunc(DateRented)

SELECT DateValue(rentaldate) AS RentalDay,<br />
   COUNT(*) AS TotalRentals,<br />
   sum(IIf(rentaltype='VHS',1,0)) AS VhsRentals,<br />
   sum(IIf(rentaltype='DVD',1,0)) AS DvdRentals<br />
FROM Rentals<br />
GROUP BY DateValue(rentaldate);