.NET Code Catto Blogger Blog: September 2010

Swamp Coast FLA Code Camp
Data Driven .NET Apps Code Crackin #31

Hey Now Everybody,

In this Post:
1 Swamp Coast Overview
2 Data Driven .NET App Session Overview
3 Vid of Session Content
4 List of Speakers (blog & twitter links)
5 Session Resources Links
6 DAL class file Code

1 Swamp Coast Overview
The Swamp Coast Code Camp #3 in SWFla is gonna be another stellar event. This code camp is @ FGCU which provided a nice venue. The best part of code camps is all the people that are there to talk tek with. I”m really looking forward to relaxin with my geek friends & learning a bunch. There are going to be some great sessions there some that I’m looking forward to seeing are mostly in WP7Dev such as:

Design for WP7 – Diane Leeper
Push Notification with Windows Phone 7 Jonas Stawski
WP7 – Tips & Tricks Kevin ‘WolfBytes’ Wolf
WP7 Marketplace, Panel, Install Fest Nikita Polyakov

Special thanks to John Dunagan & all the people who volunteered to make this event possible.

2 Data Driven .NET App Session Overview
This year my session is going to Data Driven .NET Applications. This session will be fun with a ton of content. It’s meant for any skill level, the main concept we’re going to discuss is to have content of apps driven by a data source not just static. There will be a great mix of theory & code. Here is what I plan to discuss:

DB Driven Mindset - Static vs.. Data Drive Apps
DB Dev / T-SQL
Web App ASP.NET
Data Access ADO.NET
WP7 - XML RSS Data Source
(more detailed list below)

3. Vid of Session Details

Here are some details:

DB Driven Mindset - Static vs.. Data Drive Apps
Overview & Advantages of Apps that display content from a data source
DB Dev / T-SQL
Fundamentals to Database Development
Query Window vs.. Design View
Stored Procedures
Advanced T-SQL Topics
Web App ASP.NET
Intro ASP.NET & VS10 as an IDE
.NET Controls
UI – Master Pages & CSS
Debuggin
Data Access
ADO.NET
Web Services
XML / RSS
WP7
WP7 Overview (IDE & Marketplace)
WP7 Catto Free App (my open source WP7 App)
XML RSS Data Sources
Other WP7 Apps on Emulator

4 List of Speakers (blog & twitter links)

There are many great people who are going to be there here is a list of most that I put together along with there twitter:

LIST OF TWEEPS:

Duray Akar @durayakar
Colin Blakey @ Colin Blakey
Jyoti Chawla
Oleg Sych @olegsych
Michael Wells
Jay Hill @jittery
Ken Tucker
John McFetridge
Kathy Malone
Keith Kabza @KeithKabza
Henry Lee
Greg Leonardo @biztalkdev
Christopher Bennage @bennage
Sam Abraham @wildturtle21
Todd Anglin @toddanglin
Jason Beres @jasonberes
Scott Dorman @sdorman
Chris Eargle @kodefuguru
Jason Milgram @jmilgram
Nikita Polyakov @nikitap
Herve Roggero @hroggero
Stan Shultes @fstanschultes
Jonas Stawski @jstawski
Max Trinidad @maxtrinidad
Alex Funkhouser @sherlocktech
Joe Healy @devfish
Joe Hominick @smokingjoe
Adam Jorgensen @adam_jorgensen
Scott Klein @scottklein
Diane Leeper @dianeleeper
Ryan Parsley @RyanParsley

5 Session Resources Links

Here are some other links that my be helpful regarding the content from my session:

SQL2008 Database Dev 70-433 Skills Measured
SQL 2008 DB Dev 70-433 Programming Objects
SQL 2008 DB Dev 70-433 XML Data
SSMS Toughest Program to Install
Microsoft Visual Studio Hotkey Shortcuts
.NET 4 ASP.NET ‘Skills Overview’ 70-515 Exam

6 DAL Class File code

     public class DAL
   {
        private static string ConnectionString
        {
            get
            {
                return ConfigurationManager.ConnectionStrings["100827_wpb5ConnectionString"].ConnectionString;
            }
        }

        public static DataTable ExecuteDataTable(string storedProcedureName, params SqlParameter[] arrParam)
        {
            DataTable dt = new DataTable();
            SqlConnection cn = new SqlConnection(ConnectionString);

            SqlCommand cmd = new SqlCommand(storedProcedureName, cn);
            cmd.CommandType = CommandType.StoredProcedure;


            if (cn.State == ConnectionState.Closed || cn.State == ConnectionState.Broken)
                cn.Open();

            try
            {
                if (arrParam != null)
                {
                    foreach (SqlParameter param in arrParam)
                        cmd.Parameters.Add(param);
                }

                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(dt);
                return dt;
            }
            catch (Exception ex)
            {
                throw new Exception("Error: " + ex.Message);
            }
            finally
            {
                cmd.Dispose();
                cn.Close();
            }
        }

    }