private void CBkategori_SelectedIndexChanged(object sender, EventArgs e) { string category = CBkategori.Text; query = "select name from items where category='" + category + "'"; listbox(query); } private void txtarama_TextChanged(object sender, EventArgs e) { string category = CBkategori.Text; query = "select name from items where category='" + category + "' and name like '"+txtsearch+"%'"; listbox(query); } private void listbox(string query) { ListBox.items.clear(); DataSet ds = fn.getData(query); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) ; { ListBox.items.Add(ds.Tables[0].Rows[i][0].ToString()); } }
string category= CBkategori.Text; item = new item(); var query = from item in db.item where item.name.Contains(kategori) select item; listbox.DataSource = query.ToList();
// Fill the DataSet. DataSet ds = new DataSet(); ds.Locale = CultureInfo.InvariantCulture; FillDataSet(ds); DataTable products = ds.Tables["Product"]; IEnumerable<DataRow> productsQuery = from product in products.AsEnumerable() select product; IEnumerable<DataRow> largeProducts = productsQuery.Where(p => p.Field<string>("Size") == "L"); Console.WriteLine("Products of size 'L':"); foreach (DataRow product in largeProducts) { Console.WriteLine(product.Field<string>("Name")); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)