calling stored procedures with parameters

  • Thread starter Thread starter news.verizon.net
  • Start date Start date
N

news.verizon.net

I have a form with 5 strings serving as search parameters.
I collect them from the form, store them in local variables and call a
stored procedure executing a select based on these parameters
When the parameters are left empty in the form, I nees to make a select
without conditions on that parameter.
How to call the stored procedure in VB.net, when the variables contain null
values?
 
Very good article indeed, but my problem is like
cmd.Parameters.Add("@p_FirstValue", myvar);

where mycar can be assigned plenty of values including NULL.
the null how is it passed?
 
Back
Top