//검색 버튼 눌렀을 때 실행
private void search_button_Click(object sender, EventArgs e)
{
dbConnect db = new dbConnect();
dataGridView1.RowHeadersVisible = false;
dataGridView1.Columns[0].Width = 287;
string searchMenu = string.Empty;
searchMenu = string.Format(search_Menu.Text);
string[] menuType_Combobox = { "면류", "디저트", "밥류", "음료류", "카페" };
string[] menuType = { "noodle", "dessert", "food", "drink", "cafe" };
if (combobox_menu.SelectedItem.ToString() == "전체보기")
{
DataSet ds = db.buttonSelectAll(searchMenu);
dataGridView1.DataSource = ds.Tables[0];
}
else
{
for (int i = 0; i < 5; i++)
{
if (combobox_menu.SelectedItem.ToString() == menuType_Combobox[i])
{
string menu = string.Empty;
menu = string.Format(menuType[i]);
DataSet ds = db.buttonSelect(menu, searchMenu);
dataGridView1.DataSource = ds.Tables[0];
}
}
}
}
