what is your more preferred approach for filtering a dataset in a datagridview?
dataRow.Filter or Stored Procedure using select command for filtering?
tnx pleas help me to decide ..
xxxtian
0
Light Poster
Recommended Answers
Jump to PostDepends on how much data is in the table. If you filter in your code, all the data has to be transferred from the server to your application. Not a big deal for 20 rows. It is a big deal for a million rows.
All 3 Replies
Momerath
1,327
Nearly a Senior Poster
Featured Poster
Depends on how much data is in the table. If you filter in your code, all the data has to be transferred from the server to your application. Not a big deal for 20 rows. It is a big deal for a million rows.
xxxtian
0
Light Poster
My project is a management of data so it can be a many data to be stored in the table .. your preferred approach for this situation? would you suggest to use stored procedure?
Momerath
1,327
Nearly a Senior Poster
Featured Poster
Yes, I'd use a stored procedure. Even if you have a small amount of data now, later you will have a lot more and they (stored procedures) scale better than filtering in your code.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.