Hi,
Am trying to create a basic web page to display some sales data from a MS SQL database. All the SQL work is done in a stored procedure that looks like:
sp_ATP_Get_All_OutletDayTransation @StartDate datetime, @MoDe int, @clear bit = 0
All the page needs is a date time picker and a refresh button that populates a table on the web page but I don’t normally do web stuff so am having a hard time. Also I am using notpad so there is no syntax checking.
Any help or pointers would be greatly appreciated.
thanks.
Am trying to create a basic web page to display some sales data from a MS SQL database. All the SQL work is done in a stored procedure that looks like:
sp_ATP_Get_All_OutletDayTransation @StartDate datetime, @MoDe int, @clear bit = 0
All the page needs is a date time picker and a refresh button that populates a table on the web page but I don’t normally do web stuff so am having a hard time. Also I am using notpad so there is no syntax checking.
Any help or pointers would be greatly appreciated.
thanks.