public Create_session() { InitializeComponent(); DataTable dt = new DataTable(); dt = query.Get_categories(); foreach (DataRow dr in dt.Rows) { category_textbox.Items.Add(dr["category_name"]); } }
public Admin_Home() { InitializeComponent(); var products = GetProducts(); if (products.Count > 0) { Listproduct.ItemsSource = products; } sql_queries query = new sql_queries("Data Source=(local);Initial Catalog=Auction_mangement_system;Integrated Security=True"); DataTable dt = new DataTable(); dt = query.Get_categories(); foreach (DataRow dr in dt.Rows) { Category_Combobox.Items.Add(dr["category_name"]); } }