how to add sql server database in c#.net application

ashish rohit

11y1.1kLearn iOS Programming

how to add sql server database in c#.net application ?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Jadav11y ago
Hello Ashish

Yeah ! Manoj is right. Specify it where you want to add your SQL Server ?.

If you want to add it into your website (asp.net using c#/vb) then go to your website - ->Right Click --> Add New Item (CTRL +Shift + A) - -> Find SQL Server Database - -> Click Ok

Note: After Press OK if vs10 Prompt you by saying " you want to add your Database in - -> App_data_folder or not ?" Then make it as "YES". APP_DATA_Folder will protect your Database from Intruders.

In Left hand side of VS10 Server Explorer is there you will see your database there. Name as - -> Database.mdf
Pankaj Kumar Choudhary11y ago
Hello @Ashish check this link
http://www.c-sharpcorner.com/UploadFile/5d065a/tutorial-1sql-server-database-connection-in-window-form/
Shuvojit Halder11y ago
You can add this the following step Add new item>Data> Ado.net>Generatefrom databse>new connection> your connection string> ok> add table>next this will ado.net connection. Other thing you can do direct write in your connection string into your web.config file or app.config file.
Dipankar Biswas11y ago
Hi..
Check this link. .C# - Deploy Your .Net App and install db automatically using Advanced Installer

http://www.codeproject.com/Articles/16231/Deploy-your-Application-and-Database

Thanks...
Manoj Bhoir11y ago
Hi Ashish,

How to add SQL Server database? What exactly you want to do?
Do you want to place SQL Server Database .mdf, .ldf file in your application or you want to connect your C#.Net application with SQL Server Database.

To Connect your application with SQL Database See these links :
How to connect SQL Database to your C# program, beginner's tutorial
SQL Server Database Connection in Windows Forms