I am trying to develop a portal system (in ASP.NET with C#) which will simply take information from a textarea or other input and place it into an MSSQL database (when a submit button is pressed possibly). Then at a later time, I would like another page to be able to take that data from the MSSQL database and place it into the web page simply as text.
I've found ways to do this with visual studio menus and so forth; however, I would much rather code the project as much as possible (only using software for shortcuts). Is there a way to (using C#) query data from an MSSQL database and place it into a variable (string or int) which can then be shown on the asp.net page? (and visa versa, insert variable information into a database)
I am currently running MSSQL 2005 and Visual Studio 2008 (and the adobe cs3 suite if that helps)...on windows xp.
I am open to learning anything necessary to make this happen. I already have a proficient knowledge of C#; therefore, I'd rather use that over VB if at all possible.