hi,
i have a form in which three multi select listboxes & 2 combo boxes are there.i want the to populate the datagrid according to the user selections.All the selection is from a single table even though the list/combo are populated from diff tables.please help me out of this situation.All this is done in asp.net.
regards,
jithuThen you will need to dynamically build your sql query string using a string builder or command object.
if using OleCommand then you place ? where you want to place each item.
using parameters collection to add the values that need to replace it. in SQL using a stored procedure instead then you can use named parameters, @Name etc.thanks afterburn,thanks a lot.it's working
i have a form in which three multi select listboxes & 2 combo boxes are there.i want the to populate the datagrid according to the user selections.All the selection is from a single table even though the list/combo are populated from diff tables.please help me out of this situation.All this is done in asp.net.
regards,
jithuThen you will need to dynamically build your sql query string using a string builder or command object.
if using OleCommand then you place ? where you want to place each item.
using parameters collection to add the values that need to replace it. in SQL using a stored procedure instead then you can use named parameters, @Name etc.thanks afterburn,thanks a lot.it's working