This print for content only-size & color not accurate 7" X 9-1/4" / casebound / malloy

// First, get the DataTable from the database.

InventoryDAL d = new InventoryDAL();

d.OpenConnection(ConnString);

DataTable dt = d.GetAllInventory();

d.CloseConnection();

// Now make a List to contain the records.

List records = new List();

// Copy the data table into List<> of custom contracts. 

DataTableReader reader = dt.CreateDataReader();

while (reader.Read())

{

InventoryRecord r = new InventoryRecord();

r.ID = (int)reader["CarID"];

r.Color = ((string)reader["Color"]).Trim();

r.Make = ((string)reader["Make"]).Trim();

r.PetName = ((string)reader["PetName"]).Trim();

records.Add(r);

}

// Transform List to array of InventoryRecord types.

return (InventoryRecord[])records.ToArray();

}

}

Not too much to say here. For simplicity, we are hard-coding the connection string value

(which you may need to adjust based on your machine settings) rather than storing it in our

Web.config file. Given that our data access library does all the real work of communicating with the

AutoLot database, all we need to do is pass the incoming parameters to the InsertAuto() method of

the InventoryDAL class type. The only other point of interest is the act of mapping the DataTable

object’s values into a generic list of InventoryRecord types (using a DataTableReader to do so) and

then transforming the List into an array of InventoryRecord types.