9CBS - Document Center - .NET title to DataGrid plus horizontal longitudinal total (realization in DataTable, DataAding) Dragonsuc (original) keyword DataTable
Is there a final result if implemented? ?
Protected system.web.ui.webcontrols.dataGrid DataGrid1;
///
/// Data Sources
///
DataSet CreateDataSource ()
{
DataTable DT = New DataTable ();
DataRow DR;
Dt.columns.Add (New Datacolumn ("Name", TypeOf (String));
Dt.columns.add (New Datacolumn ("Value1", TypeOf (INT32));
Dt.columns.add (New Datacolumn ("Value2", TypeOf (INT32)));
Dt.columns.add (New Datacolumn ("Value3", TypeOf (INT32));
Dt.columns.add (New Datacolumn ("Value4", TypeOf (INT32));
For (int i = 0; i <10; i )
{
DR = DT.NEWROW ();
DR [0] = I.toTOString () "Name";
DR [1] = i;
DR [2] = i 1;
DR [3] = i 2;
DR [4] = i 3;
DT.ROWS.ADD (DR);
}
Dataset mydata = new dataset ();
MyData.tables.Add (DT);
Return mydata;
}
Private Void Page_Load (Object Sender, System.EventArgs E)
{
/ / Place the user code here to initialize the page
Dataset mydata = createDataSource ();
// DataGrid1.datasource = mydata;
// DataGrid1.databind ();
DataTable myTable = new dataable ();
Datacolumn mycolum;
Foreach (datacolumn nowdatacolumn in mydata.tables [0] .columns)
{
Mycolum = new datacolumn ();
mycolum.datatype = nowDatacolumn.DataType;
Mycolum.columnname = nowDatacolumn.columnname;
MyTable.Columns.Add (MyColum);
}
Mycolum = new datacolumn ();
MyColum.DataType = system.type.gettype ("System.Int32");
Mycolum.columnname = "Total per line";
MyTable.Columns.Add (MyColum);
DataRow acountrow;
INT Datacolumns = mydata.tables [0] .columns.count;
Foreach (DataRow Nowrow In MyData.tables [0] .ROWS) {
Acountrow = mytable.newrow ();
Acountrow.itemarray = NOWROW.ITEMARRAY;
// Total per line
GetrowAccount (AcountRow, 1, 5, Datacolumns);
MyTable.Rows.Add (ACOUNTROW);
}
// Generate the total
Acountrow = mytable.newrow ();
ACOUNTROW [0] = "Agreement";
For (int count = 1; count
Foreach (DataRow Nowrow In MyTable.Rows)
{
IF (! acountrow.isnull (count))
{
IF (! acountrow.isnull (count))
ACOUNTROW [count] = convert.Toint32 (ACOUNTROW [count]) Convert.Toint32 (nowrow [count]);
}
Else acountrow [count] = norow [count] ;;
}
MyTable.Rows.Add (ACOUNTROW);
DataGrid1.datasource = MyTable;
DataGrid1.databind ();
}
///
/// Total per line
///
Private Void Gtrowaccount (DataRow AcountRow, Int Begincol, Int Endcol, Int Acountcol)
{
For (int I = begincol; i
{
if (! ACOUNTROW.INULL (Accountcol)
{
IF (! acountrow.isnull (i))
ACOUNTROW [Accountcol] = Convert.Toint32 (ACOUNTROW [Accountcol]) Convert.Toint32 (ACOUNTROW [I]);
}
Else AcountRow [Accountcol] = ACOUNTROW [i];
}
}
Disadvantages: Accessing all the data is not very good
There are other ways if there is a better way, please tell me.
