This video is from our "C# Programming with Visual Studio 2005" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Video: Comparing C# Datatypes and SQL Server Datatypes

  • ·Skill level: 300 (Intermediate)
  • ·Run Time: 15:45
  • ·Instructor: Scott Whigham

Description:

This is a helpful little video that talks about how to compare the various datatypes in C# and their corresponding datatypes in SQL Server (all versions).

Highlights from this video:
  • How to assign a checkbox's Checked state (property) to a SQL Server bit datatype in dynamic SQL
  • The C# string type and how it compares to VARCHAR/NVARCHAR in SQL Server
  • DateTime and DATETIME/SMALLDATETIME
  • Working with integers and decimals
and much more

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)

Chapter 4: Introduction to .NET and C# Concepts
Comparing C# Datatypes and SQL Server Datatypes
2 Pt. 1 - Building Our First Console Application
3 Pt. 2 - Building Our First Console Application
4 Pt. 3 - Building Our First Console Application
5 Tabs, Docking and Getting Comfortable With the Visual Studio IDE
6 Templates - Project Templates and Item Templates
7 C# Basics - Using Comments
8 C# Basics - Expressions: What They Are and How to Use Them
9 Pt. 1 - Writing If Statements and Boolean Tests
10 Pt. 2 - Using the Logical And, Or, and Not Operators, Parentheses, and Brackets
11 Pt. 3 - More Expansive If Statements Using C# Generics and Switch Statements
12 Tips for Writing Effecient If, Switch, and Select Case Statements
13 Pt. 1 - How to Write to the Windows Application Event Log
14 Pt. 2 - How to Create and Use a Custom Event Log
15 Pt. 1 - An Introduction to Operators: Unary, Binary, Ternary, and More
16 Pt. 2 - An Introduction to Operators: Unary, Binary, Ternary, and More
17 Pt. 3 - Working with Unary Operators in C#
18 Pt. 4 - Binary Operators in C#: the Assignment, Arithmetic, and Relational Operators
19 Pt. 5 - Working with the C# Logical Operators: &, |, ^, &&, and ||
20 Pt. 6 - C# Increment, Decrement, Prefix and Postfix Operators
21 Pt. 1 - Namespaces: An Introduction to Namespaces in .NET
22 Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces
23 Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces
24 Pt. 4 - Nesting Namespaces and Organizing Your Classes and Code
25 Pt. 5 - .NET Namespace Best Practices and Do's and Don'ts
26 Pt. 1 - An Introduction to CAPTCHAs and the Various Options
27 Pt. 2 - Using reCAPTCHA to Block Spam and Protect Content
28 Pt. 3 - How to Configure reCAPTCHA for Use in Your Websites
29 Pt. 4 - Using the ASP.NET Captcha Control
30 Part 1 - What is .NET?
31 Part 2 - What is .NET?
32 Part 1 - Primitive Types in C#
33 Part 2 - Primitive Types in C#
34 Part 3 - Primitive Types in C#
35 Part 4 - Primitive Types in C#
36 Part 5 - Primitive Types in C#
37 Part 6 - Primitive Types in C#

NOTE: This video is part of our C# Programming with Visual Studio 2005 course.
This video is from Chapter 4: Introduction to .NET and C# Concepts

Browse this course's videos now

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.