Programming Homework Help

Hi,

I am building a webpage on ASP.net using visual studio pro. I have already completed the basic designs and some C sharp coding. I just want the search box and the button to show the results from the stored procedure.

Please make sure you use visual studio including asp.net project and MS SQL Server for this task. I attached these files:

Aspx and aspx.cs – webpage and c sharp file

Tables spreadsheet – containing the 3 tables to import into MS database.

Stored procedure – a procedure that does basic searches with parameters for the 3 tables.

These are the tasks: 

1) Import the 3 spreadsheet tabs into MS SQL Server in a database that you will create called ‘dashboardfeatures_dev’. Make sure the tables have the same name as the spreadsheet tabs. Also save the stored procedure in your database.

2) Join the search box and button with the stored procedure so that the results are shown in the repeater e.g. if a word like appointment it typed in, it should show all appointment results. I have already done some C Sharp coding in the aspx.cs file for this task and you may need to write some more if needed.

Please do not use any asp forms on text box and button.