Simple DataSet Sorting in C#
DataSet dsTest = new DataSet();
DataTable dtSample = new DataTable("SampleTable");
DataColumn dcName = new DataColumn("Name",typeof(string));
dtSample.Columns.Add(dcName);
dtSample.Columns.Add("Age", (typeof(Int32)));
dtSample.Rows.Add("Lawrence", 25);
dtSample.Rows.Add("Dinesh", 30);
dtSample.Rows.Add("Aruna", 24);
dtSample.Rows.Add("Deb", 35);
dtSample.Rows.Add("Satish", 42);
DataView dvSample = new DataView(dtSample);
dvSample.RowFilter = "Age <> 30";
dvSample.Sort = "Age Asc";
dsTest.Tables.Add(dtSample);
Adding One more column with existing DataTable
object objCheckAmount;
if (ReceivableDT.Columns.Contains("CheckAmountWithTax") == false)
{
ReceivableDT.Columns.Add("CheckAmountWithTax", typeof(System.Double), "Paid + TaxPaid");
}
objCheckAmount = ReceivableDT.Compute("Sum(CheckAmountWithTax)", "Select = 'true' and ReceivableHeaderID='" + ReceivableHeaderID + "'");
if (objCheckAmount != DBNull.Value)
{
CheckAmount = Convert.ToDouble(objCheckAmount);
}
DataSet dsTest = new DataSet();
DataTable dtSample = new DataTable("SampleTable");
DataColumn dcName = new DataColumn("Name",typeof(string));
dtSample.Columns.Add(dcName);
dtSample.Columns.Add("Age", (typeof(Int32)));
dtSample.Rows.Add("Lawrence", 25);
dtSample.Rows.Add("Dinesh", 30);
dtSample.Rows.Add("Aruna", 24);
dtSample.Rows.Add("Deb", 35);
dtSample.Rows.Add("Satish", 42);
DataView dvSample = new DataView(dtSample);
dvSample.RowFilter = "Age <> 30";
dvSample.Sort = "Age Asc";
dsTest.Tables.Add(dtSample);
Adding One more column with existing DataTable
object objCheckAmount;
if (ReceivableDT.Columns.Contains("CheckAmountWithTax") == false)
{
ReceivableDT.Columns.Add("CheckAmountWithTax", typeof(System.Double), "Paid + TaxPaid");
}
objCheckAmount = ReceivableDT.Compute("Sum(CheckAmountWithTax)", "Select = 'true' and ReceivableHeaderID='" + ReceivableHeaderID + "'");
if (objCheckAmount != DBNull.Value)
{
CheckAmount = Convert.ToDouble(objCheckAmount);
}