public CredentialForm(SQLCredentials initialCredentials)
{
InitializeComponent();
this.initialCredentials = initialCredentials;
txtPassword.Text = (string)initialCredentials.Password.Clone();
txtUsername.Text = (string)initialCredentials.Username.Clone();
cmdOK.Click += CmdOK_Click;
cmdCancel.Click += CmdCancel_Click;
this.AcceptButton = cmdOK;
}
private void ConnectAndFillCmb(string server, string db, bool winAuth, SQLCredentials credentials, out SqlConnection conn, ComboBox cmb)
{
conn = new SqlConnection
{
ConnectionString = $"server={server};Database={db};",
};
if (winAuth)
{
conn.ConnectionString += $"Integrated Security=true;";
}
else
{
conn.ConnectionString += $"Password={credentials.Password};UID={credentials.Username}";
}
conn.Open();
cmb.Items.Clear();
foreach (var company in GetCompanies(conn))
{
cmb.Items.Add(company);
}
}
