Keith Rull » DevCast : ADO.NET Part 2 - Passing Parameters To Your SQL Statements
ATTENTION: I've decided to put the upgrade on hold due to a compatibility issue of our server environment with the latest CS installer package. CS 2008 now requires SQL Server 2005 as the backend DB but our database server currenlty has SQL Server 2000 installed on it. I'll resume the upgrade once I figure out when Telligent is releasing a patch to the schema compatibility issue. For now, we will continue to use the old version of CS while waiting for the said patch. If you have any questions about this process, please don't hesitate to post them on our forums and I'll answer them as soon as I can. Thanks for your patience and support guys! I'll let you know as soon as this is resolved. - Keith Rull

DevCast : ADO.NET Part 2 - Passing Parameters To Your SQL Statements

In part 2 of our Back To The Basics Series, Keith discusses how to pass parameters to your inline SQL Statements, read a connection string from the web.config and the use of a static class for utilities. He also refactored(a little bit) our original solution to make the code more manageable.

>> CLICK HERE TO VIEW THE TUTORIAL <<

13 minutes of information discussed in Tagalog to make it easier to understand.

*note: i'm still shaky.. still learning... hopefully next time I could make a better demo :) again, comments are welcome!

Posted Mar 05 2007, 06:55 PM by keithrull
Filed under: , , , , ,

Comments

lamia wrote re: DevCast : ADO.NET Part 2 - Passing Parameters To Your SQL Statements
on 03-05-2007 10:43 PM

Nice devcast! Maybe next time you should try to mention also the meaning of terms like refactoring. It could easily puzzle a beginner. Also, it wasn't mentioned where you could get the refactoring tool you mentioned in the tutorial(or is it?). Overall though, it's good and I understood it clearly. I'll be watching this again.

BTW, it seems like camstudio is so slow... I get horrific frame drop when I capture on a high resolution (1024 x 768). Is there a way around this? Or is camtasia simply a lot better. Thanks!

keithrull wrote re: DevCast : ADO.NET Part 2 - Passing Parameters To Your SQL Statements
on 03-05-2007 10:51 PM

Thanks Lamia! I'm striving to be better :) Hopefully i get better and better as we continue with this demos.

Don't use 1024 x768. The bigger the screen size, the bigger memory it uses.. usually 800x600 is enough. Also try using a different codec.. codecs also help with the compression of the video.. others are good but alot of the free codecs are usually bad..

the Refactor Pro! tool is from DevExpress.com..

lamia wrote re: DevCast : ADO.NET Part 2 - Passing Parameters To Your SQL Statements
on 03-06-2007 12:13 AM

Thanks! That was on my mind but I wanted to be sure. Hmmm... I wonder what I can make for Java. Hmmm...

jokiz wrote re: DevCast : ADO.NET Part 2 - Passing Parameters To Your SQL Statements
on 03-06-2007 2:14 AM

hi keith, just add a note that the filtering query is sql injection prone

keithrull wrote re: DevCast : ADO.NET Part 2 - Passing Parameters To Your SQL Statements
on 03-06-2007 8:38 AM

yes jokiz. thats the what i'm going to demonstrate on part 3 plus adding sqlparameters and exception handling.

adonhis wrote re: DevCast : ADO.NET Part 2 - Passing Parameters To Your SQL Statements
on 03-06-2007 10:09 PM

Whaaah! Gusto ko ng mag .Net. Sana may source code available to download. ;)

Comgen wrote re: DevCast : ADO.NET Part 2 - Passing Parameters To Your SQL Statements
on 03-06-2007 11:09 PM

Hi Adonhis

Starting dot net is not that hard you just have to spend some time reading Articles, Books Etc and get your self any of the following C# or VB Express 2005 and start coding. Dont forget to review your OOP.

and follow on Keiths series....

keithrull wrote re: DevCast : ADO.NET Part 2 - Passing Parameters To Your SQL Statements
on 03-11-2007 10:19 PM

Thanks Comgen :)

Add a Comment

(required)  
(optional)
(required)  
Remember Me?

Enter the numbers above:

Copyright DevPinoy 2005-2008