private void Drop_store_name_onItemSelected(object sender, EventArgs e)
{
con.Open();
OleDbCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT 사명 from company";
cmd.Connection = con;
OleDbDataReader read = cmd.ExecuteReader();
while (read.Read())
{
Drop_store_name.AddItem(read.GetString(0));
}
con.Close();
/*
*
* try
* {
* con.Open();
*
* OleDbCommand cmd = con.CreateCommand();
* cmd.CommandType = CommandType.Text;
* cmd.CommandText = "SELECT 사명 from company";
* OleDbDataReader read = cmd.ExecuteReader();
* while (read.Read())
* {
* Drop_store_name.AddItem(read.GetString(0));
* }
* con.Close();
* }
* catch
* {
* MessageBox.Show("Error");
* }
*/
/*
* try
* {
* con.Open();
* OleDbCommand cmd = con.CreateCommand();
* cmd.CommandType = CommandType.Text;
* cmd.CommandText = "SELECT 사명 from company";
* OleDbDataReader read = cmd.ExecuteReader();
* while (read.Read())
* {
* Drop_store_name.AddItem(read["사명"].ToString());
* }
* con.Close();
* }
* catch
* {
* MessageBox.Show("Error");
* }
*/
//cmd.Connection = con;
/*
* Bunifu.Framework.UI.BunifuDropdown dropdown = new Bunifu.Framework.UI.BunifuDropdown();
* void addFromDb(Bunifu.Framework.UI.BunifuDropdown dropdown)
* {
*
* OleDbCommand cmd = con.CreateCommand();
* OleDbCommand con = new OleDbCommand("server=127.0.0.1;uid=admin;password=;database=bunifu_tests;");
* con.Open();
* OleDbCommand cmd = new OleDbCommand("SELECT `gender` FROM `students` WHERE 1", con);
* OleDbCommand read = cmd.ExecuteReader();
* while (read.Read())
* {
* bunifuDropdown.Items.Add(read.GetString(0));
* }
* con.Close();
* }
*/
}
public OrderPane()
{
InitializeComponent();
Drop_store_name.Clear(); // 매입처 Dropdown 초기화
}
