Code Snippets

[Tinkerers]

Hi,

I'm looking for some code snippets around connecting to sql server db's. Data Readers, grids and the whole nine yards would be nice. I've poked around the internet and have not been able to find a good collection of code snippets around this.

Somewhere there must exist a good cheat sheet for all the possible sql server db connections and reading from them.

Ideas?

Thanks,
Paul

 

[Turkbear]

Hi,
Have you looked here:

http://www.w3schools.com/ASPNET/default.asp

or

http://aspnet.4guysfromrolla.com/articles/011106-1.aspx

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jbenson001]

http://www.connectionstrings.com

Stay away from the datasource objects.

 

[ca8msm]

You may be interested in some of the ones with "data" in the title from:

http://wiki.lessthandot.com/index.php/Category:ASP.NET

Mark,

Darlington Web Design
Experts, Information, Ideas & Knowledge
ASP.NET Tips & Tricks

 

[kss444]

http://www.connectionstrings.com

google connecting with datareader, or dataset ect..
I would also say create your own small web app or what ever, wtih each page connecting to your DB and using dataset, datareader ect..

That way you always have your code snippets.

Ordinary Programmer

 

[kss444]

Great code repository for all code lang.
Also a great plug in to Visual studio.

http://www.codekeep.net/addins.aspx

Ordinary Programmer

 

[jmeckley]

google, yahoo, msdn... they have a few references.

however I will say that 99% of these only show you how to connect. they do not provide best practices of how to manage the connection. for that I recommend 2 concepts
1. Unit Of Work (Robert "Uncle Bob" Martin has some input on this concept)
2. [Unit Of Work]/Session/Connection per View: which is specific to web development. This is very common with data access/ORM framworks. if you reseach this exchange the word/concept "Session" with "Connection".

Jason Meckley
Programmer
Specialty Bakers, Inc.