The SQL Server name is: TEW_SQLEXPRESS
The database name is myDB
using System;
using System.Data.SqlClient;
namespace CSharpConnectToSQLServer
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
string connetionString = null;
SqlConnection cnn;
connetionString = @"Server = JOHN-PC\TEW_SQLEXPRESS; Database=myDB; Trusted_Connection=Yes;";
cnn = new SqlConnection(connetionString);
try
{
cnn.Open();
Console.WriteLine("Connection Open ! ");
cnn.Close();
}
catch (Exception ex)
{
Console.WriteLine("Can not open connection ! ");
}
Console.ReadLine();
}
}
}
Thanks to: https://www.connectionstrings.com/sql-server/
Using the @ symbol: https://stackoverflow.com/questions/22311799/c-sharp-connection-string-error
The general body of the code: https://stackoverflow.com/questions/22803975/connection-to-sql-server-express-from-c-sharp
No comments:
Post a Comment