private void btnTestConnect_Click(object sender, EventArgs e)
{
string SQLServer = txtSQLServer.Text;
if (!validateTestCon())
{
MessageBox.Show("Please fill SQL Server or username, password");
}
if (chbWindowAuth.Checked)
{
connector = new SQLConnector(SQLServer);
}
else
{
connector = new SQLConnector(SQLServer, txtUserName.Text, txtPassWord.Text);
}
if (!connector.CheckConnection())
{
MessageBox.Show("Please check your information filled");
btnTestConnect.Text = "Test Connection";
return;
}
DataTable catelog = connector.GetCatalogList();
txtCatalog.DataSource = catelog;
txtCatalog.DisplayMember = "name";
txtCatalog.Enabled = true;
}
private void btnTestConnect_Click(object sender, EventArgs e)
{
string SQLServer = "DESKTOP-GR8RADT\\SQLEXPRESS";
connector = new SQLConnector(SQLServer);
DataTable catelog = connector.GetCatalogList();
cbxCatalog.DataSource = catelog;
cbxCatalog.DisplayMember = "name";
cbxCatalog.Enabled = true;
//using(var db = new MiniBookStoreEntities())
//{
// Debug.WriteLine("vao day");
// var data = db.Company;
// foreach(var c in data)
// {
// Debug.WriteLine(c.Company_ID);
// }
// Debug.WriteLine("End loop");
// Company a = new Company { Company_Name = "quitest" };
// db.Company.AddObject(a);
// db.SaveChanges();
// Debug.WriteLine("End save");
//}
}