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;
            
forint i=0;i<dt.Rows.Count-1;i++ )
            
{
                
string str=dt.Rows[i][0].ToString();
                d1.Add(str,
typeof(System.Int32));
            }

            
            
return newTable;
        }

posted on 2006-06-23 15:47  过江  阅读(288)  评论(0编辑  收藏  举报