62,046
社区成员
发帖
与我相关
我的任务
分享
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
CreateDataTable();
}
/// <summary>
/// 构造DataTable
/// </summary>
void CreateDataTable()
{
// 1 声明一个DataTable
DataTable myDataTable = new DataTable("ParentTable");
// 2 生成一个列,并放入DataTable中
DataColumn myDataColumn1 = new DataColumn();
myDataColumn1.DataType = System.Type.GetType("System.Int32"); //该列的数据类型
myDataColumn1.ColumnName = "学号"; //该列的名称
myDataTable.Columns.Add(myDataColumn1);
// 3 生成第二个列,并放入DataTable中
DataColumn myDataColumn2 = new DataColumn();
myDataColumn2.DataType = System.Type.GetType("System.String"); //该列的数据类型
myDataColumn2.ColumnName = "姓名"; //该列的名称
myDataTable.Columns.Add(myDataColumn2);
// 4 将"学号"列作为DataTable的主键
DataColumn[] PrimaryKeyColumns = new DataColumn[1];
PrimaryKeyColumns[0] = myDataTable.Columns["学号"];
myDataTable.PrimaryKey = PrimaryKeyColumns;
// 5 向DataTable中插入一行数据
DataRow myDataRow1 = myDataTable.NewRow();
myDataRow1["学号"] = 1;
myDataRow1["姓名"] = "张三";
myDataTable.Rows.Add(myDataRow1);
// 6 继续插入第二行数据
DataRow myDataRow2 = myDataTable.NewRow();
myDataRow2["学号"] = 2;
myDataRow2["姓名"] = "李四";
myDataTable.Rows.Add(myDataRow2);
// 7 输出DataTable中的数据
Page.Response.Write(" <table border=1 width=200>");
for (int i = 0; i < 2; i++)
{
Page.Response.Write(" <tr>");
for (int j = 0; j < 2; j++)
{
Page.Response.Write(" <td>" + myDataTable.Rows[i].ItemArray[j] + " </td>");
}
Page.Response.Write(" </tr>");
}
Page.Response.Write(" </table>");
}
}
///偶主要是 4,设置主键不懂。
DataColumn[] PrimaryKeyColumns = new DataColumn[1];
PrimaryKeyColumns[0] = myDataTable.Columns["学号"];///这里为啥用0,用1或者其他可以么?这个东东里面是啥东西?是后面赋值的1,2么?
myDataTable.PrimaryKey = PrimaryKeyColumns;///
谢谢