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 ..

Recommended Answers

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.

Jump to Post

All 3 Replies

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.

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?

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 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.