private void cboDBName_Click(object sender, EventArgs e)
{
try
{
var sqr = new SqlReader();
if (txtLogin.Enabled)
{
sqr = new SqlReader(cboSQLServer.Text, "master", txtLogin.Text, txtPassword.Text);
}
else
{
sqr = new SqlReader(cboSQLServer.Text, "master");
}
using (var tbl = sqr.GetDatabases())
{
cboDBName.Items.Clear();
foreach (DataRow r in tbl.Rows)
{
string s = r["name"].ToString();
cboDBName.Items.Add(s.TrimEnd(new char[] { '\\' }));
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public FrmTransfer()
{
InitializeComponent();
_exr = new ExcelReader();
_sqr = new SqlReader();
}
private void cmdOpenSql_Click(object sender, EventArgs e)
{
try
{
using (var frm = new FrmConfig())
{
frm.ShowDialog();
if (!frm._status) return;
if (frm.txtLogin.Enabled)
{
_sqr = new SqlReader(frm.cboSQLServer.Text, frm.cboDBName.Text, frm.txtLogin.Text, frm.txtPassword.Text);
}
else
{
_sqr = new SqlReader(frm.cboSQLServer.Text, frm.cboDBName.Text);
}
}
cboSqlTable.Items.Clear();
cboSqlTable.Text = null;
foreach (string s in _sqr.GetTable())
{
cboSqlTable.Items.Add(s);
}
if (cboSqlTable.Items.Count > 0)
{
cboSqlTable.SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}