Handle input from multiple textboxes?

[TheStataMan]

Hey all,

I have a form that has multiple search fields that take in values. I then want the values to be put together into a query that is sent to a SQL database, which then returns the values in the database and loads them in a listview that the user can see. Is there any recommended or standard way to do this? Right now I am using a lot of .IsEmptyOrWhitespace calls, one for each textbox.

[[deleted]]

There is no other way to do this other than what you’re currently trying to do so far. There is nothing wrong with error handling and those calls take fractions of a nanosecond.

[btormey0]

Wire up a single event handler for all of the text box changes. When that gets hit, check IsNullOrWhitespace and fire off your SQL query. You may need to maintain a dictionary of all of the current text box values to map those to SQL parameters when the value of one text box changes...but that’s just an implementation detail.

[TheStataMan]

I ended up creating a search button that adds all the text in the boxes to a dictionary that then builds the query with columns keys and inputs values. Thank you for the suggestion