Database connectivity...

Question

Hi I am new in visual studio i want to know how SQL Server database is connected through C# application. Please suggest.

Gnanavel Sekar · Answer

Refer the below Links Windows https://www.codeproject.com/Articles/823854/How-to-connect-SQL-Database-to-your-Csharp-program Web https://www.codeproject.com/Tips/1038536/Day-Database-Connectivity-ASP-NET-Csharp-with-SQL for more.. http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm if stuck anywhere let us know

Jitendra Shekhawat · Answer

SqlConnection con = new SqlConnection(Data Source=.\SQLEXPRESS;Initial Catalog=DatabaseName;Integrated Security=true;); http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm

SARDAR MUKHTAR · Answer

Use the following code to connect with database --------------------------------------------------------------- using System.Data; using System.Data.SqlClient; //Execution DataSet ds=_Get_Dataset(Select * from Table); public DataSet _Get_Dataset(string query) { //create dataset object to fill datatable into it. DataSet ds = new DataSet(); //Create a Connection to communicate with database using (SqlConnection con = new SqlConnection(Data Source=ServerName;database=DatabaseName;user id=UserId;password=Password;)) { try { //DataAdapter. In ADO.NET a DataAdapter functions as a bridge between a data source and a disconnected data class such as a DataSet. SqlDataAdapter da = new SqlDataAdapter(query con); da.Fill(ds); return ds; } catch (Exception) { throw; } } }

Jitendra Shekhawat · Answer

http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm https://www.codeproject.com/Articles/823854/How-to-connect-SQL-Database-to-your-Csharp-program https://msdn.microsoft.com/en-us/library/s4yys16a(v=vs.90).aspx

Ranjeet Patra · Answer

https://www.codeproject.com/Articles/4416/Beginners-guide-to-accessing-SQL-Server-through-C

Ahmed JS · Answer

Refer this link http://sqlneed.blogspot.com/2013/08/Connect-to-SQL-Databse-C-sharp.html