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; }