How do i search through my Datatable. I know how to do it when there is a Datagridview involved, but i dont have one in this case.
I know they say you should do this
DataRow foundRow = dataSet1.Tables["AnyTable"].Rows.Find(s);
Something like that, but i have no idea what the DAtaset1 is?
this is my code.
DataTable dTable = new DataTable(); OleDbDataAdapter dAdapter; String connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\Resources\\db1.mdb"; string query = "SELECT * FROM AutoReminder"; //create an OleDbDataAdapter to execute the query dAdapter = new OleDbDataAdapter(query, connString); //create a command builder OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(dAdapter); //fill the DataTable dAdapter.Fill(dTable);
So i filled up my datatable, but now how do i search thought it, say for a number bigger that 5 in the "Amount" column in AutoReminder? As i have No Clue what so ever.
Thank you =)