Looking for specific asp.net/SQL Server 2008 tutorial...please

• greatsqldba

  SSC Enthusiast

  Points: 161

  More actions

  July 30, 2011 at 5:06 pm

  #104083

  I have been a dba for over 11 years. I use to do a lot of development with Classic ASP, VBScript, JavaScript, COM objects, and so on. I haven't truly had an opportunity until now to find a really good tutorial to show how to insert, update, and delete data using asp.net and SQL Server. I currently have SQL Server 2008. I spent a majority of around 45 minutes looking for ways to get this project of mine going. I also have MS Visual Studio 2010 Express if that helps. I have yet to cross over to the ASP.NET side to use as a database front end if you would. Having to insert, update, and delete data from the ms sql server management studio has become quite tedious especially when you need to enter data that could potentially fit in a varchar(3000) variable.

  Any help would be tremendously appreciated.

  Thanks for any help in advance. :w00t:

• Sean Lange

  SSC Guru

  Points: 286602

  More actions

  August 2, 2011 at 2:21 pm

  #1362627

  Here try this link. It has plenty of great examples.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/