database

Question

how to connect internal database in visual studio 2012?

Rajeesh Menoth · Answer

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/

Raja T · Answer

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

Arul R · Answer

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