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.

C# with SQL DataBase

Answers (6)