datatable 生成自动增长列的方法
DataSet ds = SelectSqlDS(sql);//SQL生成一个dataset
DataColumn column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "SequenceNumber";
column.AutoIncrement = true;
column.AutoIncrementSeed = 1;
column.AutoIncrementStep = 1;
DataTable table = new DataTable("table");
table.Columns.Add(column);
DataTableReader dataTableReader = new DataTableReader(ds.Tables[0]);
table.Load(dataTableReader);
return table.DefaultView;