How to Insert New Row Into DataTable or TableRow

[Kelvin]

Same as subject !

[curllion]

....
DataRow myDataRow = myDataTable.NewRow();
myDataRow[0]=.....;
myDataRow[1]=.....;
myDataRow[2]=.....;
myDataRow[3]=.....;
....
myDataTable.Rows.Add(myDataRow);
....

[Kelvin]

I don't know why I can't Insert Bank Row Into DataTable Between Rows.
Please comment below sources code. Thanks

DataRow dr = myTable.NewRow();

for (i=0; i > myTable.Rows.Count; i++)
{
if (myOrderNo != myTable.Rows[5].ToString())
{

mySubTotal = Convert.ToDouble(myTotalPrice) * (100 -
Convert.ToDouble (myTable.Rows[7])) / 100;

dr["CustNo"] = "Sub Total : ";
dr["TotalPrice"] = mySubTotal;

myTable.Rows.Add(dr);

myGrandTotal = myGrandTotal + Convert.ToDouble(mySubTotal);

myOrderNo = myTable.Rows[5].ToString();

mySubTotal = 0;
myTotalPrice = 0;

}
else
{
myTotalPrice = myTotalPrice + Convert.ToDouble(myTable.Rows[17])
;
}
}

It is out of my expectation result.

Order No Description Item Total
11111111 XXXXXXX A 100
11111111 XXXXXXX B 200
SubTotal 300

22222222 XXXXXXX A 300
22222222 XXXXXXX B 200
SubTotal 500

Grand Total 800
dr["CustNo"] = "Grand Total : ";

dr["TotalPrice"] = myGrandTotal;

myTable.Rows.Add(dr);

"curllion" <cu******@163.com> wrote in message news:<eR**************@TK2MSFTNGP09.phx.gbl>...

...
DataRow myDataRow = myDataTable.NewRow();
myDataRow[0]=.....;
myDataRow[1]=.....;
myDataRow[2]=.....;
myDataRow[3]=.....;
...
myDataTable.Rows.Add(myDataRow);
...