David Godistei

David Godistei

  • 1.3k
  • 136
  • 1.8k

How do I correct my stored Procedure code to display data on Win. Form

Feb 5 2025 12:34 AM

In a project I have created a Stored Procedure by collecting information from the Employees and Salaries tables respectively. I set @Year with int datatype as my first Parameter column. I also set @Month with varchar datatype as my second Parameter column. On the Windows Form when I enter the year and the month in the parameter textboxes I want the required data to display, but it could not. If I had used int datatype throughout it would have displayed the data.

 

Probably I would have to correct something in the stored procedure code which I do not know. Please I will appreciate if someone can help me succeed. I therefore, want to attach here with images of the code and the form. Thanks