手动编写代码创建数据表

我们可以通过手动编写代码的方式，创建数据表，如下代码所示：

DataTable GetData() { 　// This method creates a DataTable with four rows. Each row has the 　// following schema: 　// PictureID int 　// PictureURL string 　// Title string 　// DateAdded datetime 　DataTable dt = new DataTable(); 　// define the table’s schema 　dt.Columns.Add(new DataColumn("PictureID", typeof(int))); 　dt.Columns.Add(new DataColumn("PictureURL", typeof(string))); 　dt.Columns.Add(new DataColumn("Title", typeof(string))); 　dt.Columns.Add(new DataColumn("DateAdded", typeof(DateTime))); 　// Create the four records 　DataRow dr = dt.NewRow(); 　dr["PictureID"] = 1; 　dr["PictureURL"] = ResolveUrl("~/DisplayingImages/Images/Blue hills.jpg"); 　dr["Title"] = "Blue Hills"; 　dr["DateAdded"] = new DateTime(2005, 1, 15); 　dt.Rows.Add(dr); 　dr = dt.NewRow(); 　dr["PictureID"] = 2; 　dr["PictureURL"] = ResolveUrl("~/DisplayingImages/Images/Sunset.jpg"); 　dr["Title"] = "Sunset"; 　dr["DateAdded"] = new DateTime(2005, 1, 21); 　dt.Rows.Add(dr); 　dr = dt.NewRow(); 　dr["PictureID"] = 3; 　dr["PictureURL"] = 　ResolveUrl("~/DisplayingImages/Images/Water lilies.jpg"); 　dr["Title"] = "Water Lilies"; 　dr["DateAdded"] = new DateTime(2005, 2, 1); 　dt.Rows.Add(dr); 　dr = dt.NewRow(); 　dr["PictureID"] = 4; 　dr["PictureURL"] = ResolveUrl("~/DisplayingImages/Images/Winter.jpg"); 　dr["Title"] = "Winter"; 　dr["DateAdded"] = new DateTime(2005, 2, 18); 　dt.Rows.Add(dr); 　return dt; }

　　程序运行后，结果如下图所示