I don't know if this is the correct forum...

Question

...but I'm new to using SQL in C# and I need to know how to do a couple of things:

1) How do I create a SQL database?
2) Once I've created it, how do I add tables and columns to it?
3) Once I've added the table and columns how do I insert data into the tables and columns?

I've done some reading of the documentation and it looks like I need to create a SqlConnection object and pass it a bunch of strings, but I can't figure out what each of the strings mean, or if the database needs to already exist before I create the SqlConnection command.

If this is the wrong forum to post this question, then please point me to the correct one. I have a project that is due by Monday, and if I don't complete it, then I'm probably going to get fired- so somebody, please, please help me!
Thanks,
--Jeremy

Answer 1

Hi,

This forum handles requests on Open Protocols Specifications documentation issues.
We assist customers in developing systems, services, and applications that are interoperable with Windows and Office Products. The Open Protocol Specifications can be found at: http://msdn2.microsoft.com/en-us/library/cc203350.aspx.

Since your post does not appear to be related to the Open Protocols Specifications documentation set, I suggest the following:

SQL Server Programming Reference
http://msdn.microsoft.com/en-us/library/dd206988.aspx

MSDN Library: Microsoft SQL Server
http://msdn.microsoft.com/en-us/library/bb545450.aspx

MSDN Library: How Do I Find Tutorials (Database Engine)
http://msdn.microsoft.com/en-us/library/ms169620.aspx

TechNet Forums: SQL Server
http://forums.microsoft.com/TechNet/default.aspx?ForumGroupID=93&SiteID=17

Best Regards,
Edgar