public static DataTable AllbyApply2( )
{//
DataTable dt=new DataTable();
DataTable lastTable=new DataTable();
DataColumnCollection d=dt.Columns;
d.Add("ID",typeof(System.Int32));
SqlParameter[] arParams = new SqlParameter[1];
SqlDataReader dr = null;
dr = SqlHelper.ExecuteReader(Globals.ConString, CommandType.StoredProcedure,"GjTest1");
while (dr.Read())
{
string a=dr.GetInt32(0).ToString();
DataRow row1=dt.NewRow();
row1["ID"]=a;
dt.Rows.Add(row1);
}
DataTable newTable = new DataTable();
DataColumnCollection d1=newTable.Columns;
int count=dt.Rows.Count;
for( int i=0;i<dt.Rows.Count-1;i++ )
{
string str=dt.Rows[i][0].ToString();
d1.Add(str,typeof(System.Int32));
}
return newTable;
}

浙公网安备 33010602011771号