public string OpenConnection(string serverName)
{
this.Auth = AuthtenticationType.WindowsAuthentication;
try
{
conn.ConnectionString = "Data Source=" + serverName + ";Integrated Security=true;";
conn.Open();
}
catch (Exception ex) { return(ex.Message); }
return("Connection open");
}
public string OpenConnection(string serverName, string userName, string password)
{
this.Auth = AuthtenticationType.SQLServerAuthentication;
try
{
conn.ConnectionString = "Data Source=" + serverName + ";Integrated Security=false;User ID=" +
userName + ";Password="******";";
conn.Open();
}
catch (Exception ex) { return(ex.Message); }
return("Connection open");
}
