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

Question

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

Nilesh Jadav · Answer

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 Choudhary · Answer

Hello @Ashish check this link http://www.c-sharpcorner.com/UploadFile/5d065a/tutorial-1sql-server-database-connection-in-window-form/

Shuvojit Halder · Answer

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 Biswas · Answer

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 Bhoir · Answer

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