protected void load_Products_Click(object sender, EventArgs e) { product prod1 = new product("001", "Jeff", "A man", 2, 100); product prod2 = new product("002", "Geoff", "A smaller man", 1, 140); product prod3 = new product("003", "Water", "Some water", 30, 283); product prod4 = new product("004", "Air", "You can breathe it", 0, 999); product prod5 = new product("005", "Black", "Its just some black", 56, 458); AllProducts = new Dictionary <string, product>(); AllProducts.Add("001", prod1); AllProducts.Add("002", prod2); AllProducts.Add("003", prod3); AllProducts.Add("004", prod4); AllProducts.Add("005", prod5); Drop1.DataSource = AllProducts; Drop1.DataTextField = "Value"; Drop1.DataValueField = "Key"; Drop1.DataBind(); }
private void showfaculty() { con.Open(); string query = "select fname from faculty"; sqc = new SqlCommand(query, con); sdr = sqc.ExecuteReader(); Drop1.DataSource = sdr; Drop1.Items.Clear(); Drop1.Items.Add("....Enter your faculty...."); Drop1.DataTextField = "fname"; Drop1.DataValueField = "fname"; Drop1.DataBind(); con.Close(); }