Fill tableAdapter with selected data only
Posted on 2011-03-01
I would like to fill datagrid with data filtered by date. I can fill all the data into tableadapter and then use filter, but i would like to avoid that since after a while there is lot's of data and everything start to slow down.
currently i am using Me.TableAdapter.Fill(Me.db_data.Dates), is there simple way to pull only selected data from database and ignoring the rest.
For example Me.TableAdapter.Fill(Me.db_data.Dates, "20110302") or something like that.