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 ..
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.
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.