.NET (Core and Framework)

H.R wrote:

5. my SqlConnection in application:
"Server=192.168.0.205\\MYSQLSRV; Initial Catalog=Exam; Integrated Security=False; Persist Security Info=False; User ID=admin;Password=1001";

private void ConnectToDb()
{
SqlConnection sqlConn = new SqlConnection("Server=192.168.0.205\\MYSQLSRV; Initial Catalog=Exam; Integrated Security=False; Persist Security Info=False; User ID=admin;Password=1001");

sqlConn.Open(); // debug here. If THIS throws an exception, well, i can't help you

sqlConn.Close(); //if it doesn't, you're good to go.

}

string connstring = "Data Source = .\\ABC;Initial Catalog = XYZ; Integrated Security = True";     

    SqlConnection conn = new SqlConnection(connstring);
    SqlCommand comm = new SqlCommand();
    comm.CommandText = "Select * From DummyTable";
    comm.Connection = conn;    
    conn.Open();
    
    comm.ExecuteScalar();
    conn.Close();