Hello there, Although I am an amateur coder with a small amount of experience with a variety of languages, I'm having trouble with Visual Studio and a .NET web application.
I'm a web admin for a local garden centre. Up until recently I have been responsible for the content of our e-commerce site, which has been hosted by the company who built and designed the site. This is managed through a custom CMS.
Recently, we cut the design and maintenance ties with the company who built the site, although they continue to host and provide support. I received a copy of the website and it's associated MS SQL database.
Navigating the code in Visual Web Developer Express Edition 2008 is not a problem. ANd after a little poking around I have successfully configured a local connection to the database. However, the application does not appear to display information from the database. None of the data sources appeared to be configured.
In design view, any pages which pull information from the database have the controls visible without the data. Clicking on the '>' on an active datalist/datagrid brings p the Tasks dialog. No Data Source is displayed in the drop down box. I can manually step through the process of choosing a new data source , and choose what appears to be the appropriate stored procedure for the control, but I do get a bit lost when asked to define cookie and session parameters for the SQL statement.
Shouldn't the data source procedure be stored within the code? Connections between the database and the web app are not being made, how can I easily restore them? (I do have a connection to a local copy of the website listed in the database explorer window)
The website is in ASP.NET with C# behind and an MS SQL 2005 database.
Thanks to anyone who can help