Member Avatar for xxxtian

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

  • 2 Contributors
  • 3 Replies
  • 119 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by Momerath
Member Avatar for Momerath

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.

Member Avatar for xxxtian

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?

Member Avatar for Momerath

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.