C# with SQL DataBase

Question

Hello everyone! I have a problem. I can't create (no, I can create) but I can't connect to SQL DataBase from VS C#..

I'm using Visual Studio C# 2008 Express ... so... please, describe me how to create and connect to this Base.... I'm in really big trouble... Please..

thanks...

Stefan · Answer

Here's a tutorial: http://www.dreamincode.net/forums/showtopic31314.htm

Vijaya Kadiyala · Answer

Hi Can you post the code to review! Thanks -- Vijaya Kadiyala www.DotNetVJ.com

mahesh kumar · Answer

to connect to SQL database Sql connection con=new Sqlconnection(user id= ursidname;password=password;database=databasename); if u want to connect without username or password con=(database=name;Integrited Security=true);

Artem · Answer

Yes please it'll be very helpful... So and if possible little how to create a new base in C# (and connect to it)... I just think maybe I doing smth. wrong?..

Stefan · Answer

You can connect to the database by either using ADO.NET or Linq-to-SQL. ADO.NET takes a little work. Linq-to-SQL is easier faster and the syntax is more natural. If you need any examples please post back.

Niradhip Chakraborty · Answer

You can create a connectionstring in config file and refer it in your page to connect with database.