1.
DataRow other = datatable.NewRow();
other["DEFECTCODE"] = "Others";
other["NGQTY"] = OthersNGQTY.ToString();
other["COUNTRATE"] = 1;
datatable.Rows.Add(other);
DataTable endtable = datatable.Clone();
DataRow drow = null; ;
for (int i = 0; i < datatable.Rows.Count; i++)
{
if (datatable.Rows[i]["DEFECTCODE"].ToString().Equals("Others"))
{
drow = datatable.Rows[i];
}
else
{
endtable.ImportRow(datatable.Rows[i]);
}
}
endtable.ImportRow(drow);