Construct a datatable to add a new row column (I don't know how to implement it using the stored procedure, and use C # To join the table temporarily)

///   <Summary>
/// Construct a user information detail table
///   </Summary>
///   <Returns> </returns>
Public   Static Datatable getalldetail ()
{
Datatable dt =   New Datatable ();
DT. Columns. Add ( " UID " , Typeof (System. int32 )); // User ID
DT. Columns. Add ( " Username " , Typeof (System. String )); // User Name
DT. Columns. Add ( " Fileover " , Typeof (System. int32 )); // Number of processed items
DT. Columns. Add ( " Fileundeal " , Typeof (System. int32 )); // Number of unprocessed items
DT. Columns. Add ( " Filedealing " , Typeof (System. int32 )); // Number of processes
Datatable dtusr = Userbll. getall (); // User List
For ( Int I =   0 ; I < Dtusr. Rows. Count; I ++ ) // Processing here
{
Datarow Dr = DT. newrow ();
String UID = Dtusr. Rows [I] [ " UID " ]. Tostring ();
Dr [ " UID " ] = Convert. toint32 (UID );
Dr [ " Username " ] = Dtusr. Rows [I] [ " Username " ]. Tostring ();;
Dr [ " Fileover " ] = Regfilesbll. gettotalbyuidprocess (UID, 10 , 10 );
Dr [ " Fileundeal " ] = Regfilesbll. gettotalbyuidprocess (UID, 0 , 0 );
Dr [ " Filedealing " ] = Regfilesbll. gettotalbyuidprocess (UID, 1 , 9 );
DT. Rows. Add (DR );
}
Return DT;
}