手工建表的步骤
1
<%
2
DataTable dtblCart;
3
DataRow drowItem;
4
// Display DataTable
5
6
// Create DataTable
7
dtblCart = new DataTable( "Cart" );
8
9
// Create Columns
10
DataColumn dcolColumn = new DataColumn( "ProductID", typeof( Int32 ) );
11
dtblCart.Columns.Add( dcolColumn );
12
dcolColumn = new DataColumn( "ProductName", typeof( string ) );
13
dtblCart.Columns.Add( dcolColumn );
14
dcolColumn = new DataColumn( "ProductCategory", typeof( string ) );
15
dtblCart.Columns.Add( dcolColumn );
16
dcolColumn = new DataColumn( "ProductPrice", typeof( Decimal ) );
17
dtblCart.Columns.Add( dcolColumn );
18
19
// Add Rows
20
drowItem = dtblCart.NewRow();
21
drowItem[ "ProductID" ] = 12;
22
drowItem[ "ProductName" ] = "Anchor Steam";
23
drowItem[ "ProductCategory" ] = "Beer";
24
drowItem[ "ProductPrice" ] = 7.90;
25
dtblCart.Rows.Add( drowItem );
26
//Add Rows
27
drowItem = dtblCart.NewRow();
28
drowItem[ "ProductID" ] = 13;
29
drowItem[ "ProductName" ] = "Samuel Adams";
30
drowItem[ "ProductCategory" ] = "Beer";
31
drowItem[ "ProductPrice" ] = 8.67;
32
dtblCart.Rows.Add( drowItem );
33
foreach (DataRow row in dtblCart.Rows)
34
{
35
foreach (DataColumn column in dtblCart.Columns)
36
{
37
Response.Write( row[ column ]);
38
}
39
}
40
41
%>
42
<%2
DataTable dtblCart;3
DataRow drowItem;4
// Display DataTable5

6
// Create DataTable7
dtblCart = new DataTable( "Cart" );8

9
// Create Columns10
DataColumn dcolColumn = new DataColumn( "ProductID", typeof( Int32 ) );11
dtblCart.Columns.Add( dcolColumn );12
dcolColumn = new DataColumn( "ProductName", typeof( string ) );13
dtblCart.Columns.Add( dcolColumn );14
dcolColumn = new DataColumn( "ProductCategory", typeof( string ) );15
dtblCart.Columns.Add( dcolColumn );16
dcolColumn = new DataColumn( "ProductPrice", typeof( Decimal ) );17
dtblCart.Columns.Add( dcolColumn );18

19
// Add Rows20
drowItem = dtblCart.NewRow();21
drowItem[ "ProductID" ] = 12;22
drowItem[ "ProductName" ] = "Anchor Steam";23
drowItem[ "ProductCategory" ] = "Beer";24
drowItem[ "ProductPrice" ] = 7.90;25
dtblCart.Rows.Add( drowItem );26
//Add Rows27
drowItem = dtblCart.NewRow();28
drowItem[ "ProductID" ] = 13;29
drowItem[ "ProductName" ] = "Samuel Adams";30
drowItem[ "ProductCategory" ] = "Beer";31
drowItem[ "ProductPrice" ] = 8.67;32
dtblCart.Rows.Add( drowItem );33
foreach (DataRow row in dtblCart.Rows)34
{35
foreach (DataColumn column in dtblCart.Columns)36
{37
Response.Write( row[ column ]);38
}39
} 40

41
%>42



浙公网安备 33010602011771号