Database connectivity...

Ganesh Ranalkar

9y1kLearn iOS Programming

Hi,

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

6 Replies

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

Jitendra Shekhawat9y ago
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 MUKHTAR9y ago
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 Shekhawat9y ago
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 Patra9y ago
https://www.codeproject.com/Articles/4416/Beginners-guide-to-accessing-SQL-Server-through-C
Ahmed JS9y ago
Refer this link

http://sqlneed.blogspot.com/2013/08/Connect-to-SQL-Databse-C-sharp.html
Gnanavel Sekar9y ago
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