public DataTable GetSubsetOfDataTable()
{
DataTable dt;
var data = new Module6DataAccess();
dt = data.GetTransactionsAsDataTable();
var dtNew = dt.Clone();
// V1, using loop
//var rows = dt.Select("Amount < 25");
//foreach(var row in rows)
//{
// // importRow needs to be used because
// // a row instance cannot belong to more than one DataTable
// dtNew.ImportRow(row);
//}
// V2 using helper method
dtNew = dt.Select("Amount < 25").CopyToDataTable();
////
dtNew.AcceptChanges();
return(dtNew);
}
private void button1_Click(object sender, EventArgs e)
{
var db = new Module6DataAccess();
var dt = db.GetBooksAsDataTable();
textBox1.Text = db.ResultText;
}
