database

Tushar Wavare

10y932.NET

how to connect internal database in visual studio 2012?

3 Replies

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

Rajeesh Menoth10y ago
Hi,

Add your db details in your Web Config.

Code Snippet In Web.Config:

Windows authentication

<add name="windowsConnection" connectionString="Server=localhost; Database=databasename; Trusted_Connection=True;" />

SQL server authentication

<add name="Sqlserverconnection" connectionstring="server=localhost; Database=databasename;uid=db; password=123 "/>

Reference :

http://www.c-sharpcorner.com/blogs/solve-error-login-failed-for-user-in-c-sharp-and-sql1

https://rajeeshmenoth.wordpress.com/2014/09/03/login-failed-for-user-c-with-sqlconnection-error/
0
Raja T10y ago
Hello Tushar, Try like

using System.Data.SqlClient;
using System.Data;

SqlConnection con = new SqlConnection("server=localhost;database=Text;uid=sa;pwd=passwd");

try
{
con.Open();
}
catch(Exception Ex)
{

}

more detail check out below links

http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm

http://www.c-sharpcorner.com/UploadFile/b8d90a/connect-oledb-database-in-C-Sharp-in-easy-steps/

http://www.homeandlearn.co.uk/csharp/csharp_s12p5.html

http://www.codeproject.com/Articles/823854/How-to-connect-SQL-Database-to-your-Csharp-program

0
Arul R10y ago
Kindly refer the below links, Hope this will solve your problem.

https://www.youtube.com/watch?v=HwA-tNvU3hw
https://www.youtube.com/watch?v=M8Q8c4bp8r0

http://blogs.msdn.com/b/bethmassi/archive/2012/04/19/working-with-sql-server-localdb-in-lightswitch-projects-in-visual-studio-11.aspx

https://msdn.microsoft.com/en-us/library/fxk9yw1t.aspx

Let me know for any thing more....
If your problem solved means kindly Accept my answer
0