By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,552 Members | 893 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,552 IT Pros & Developers. It's quick & easy.

How to call stored procedure in vb?

P: 5
this is my stored procedure... how can i get the value of a datetimepicker1 in vb.net form and stored it in @date1 and @date2
Expand|Select|Wrap|Line Numbers
  1.  
  2. CREATE PROCEDURE SAT
  3.  
  4.     @date1 datetime,
  5.     @date2 datetime
  6. AS
  7.  
  8.     SELECT DISTINCT cnsgne, broker,
  9.         COUNT(case when cntsze=20 then cntsze end) as '20',
  10.         COUNT(case when cntsze=40 then cntsze end) as '40',
  11.         COUNT(case when cntsze=45 then cntsze end) as '45'
  12.     FROM CYMgps
  13.     WHERE (sysdte BETWEEN @date1 and @date2)
  14.     GROUP BY cnsgne, broker
  15.     ORDER BY cnsgne asc
  16.     RETURN
  17.  
  18.  
  19.  
Jan 16 '13 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.