public SqlConnection GetSqlConn(DbCredentials d)
    {
        try
        {

            dbconn = new SqlConnection();
            string str = @"server=" + d.server + "; user=" + d.user + "; password=" + d.password + "; database=" + d.dbName + "; Integrated Security = True; Connect Timeout=" + 7;
            dbconn.ConnectionString = str;

           dbconn.Open();

        }
        catch (Exception ex)
        {
            return null;

        }
        return dbconn;
    }


public class DbCredentials
{
    public string server { get; set; }
    public string user { get; set; }
    public string password { get; set; }
    public string dbName { get; set; }


}