//----------------------------------------------------------keyword search...textchange event--------------------------// protected void TxtSearch_TextChanged(object sender, EventArgs e) { ControlVisibleFalse(); DdlCatagory.SelectedItem.Text = "All"; DdlUIS.SelectedItem.Text = "All"; string keyword = TxtSearch.Text; sList = InventoryLogic.SearchInventory(keyword); Session["list"] = sList; GridViewInventory.DataSource = sList; GridViewInventory.DataBind(); LblMsg.Text = "*Showing result for" + " " + keyword; }
protected void bindInventoryGridView() { String connectionString = ConfigurationManager.ConnectionStrings["Vet_DataConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT Medication_ID, Name, Quantity " + "FROM Inventory " + "WHERE Name LIKE '%' + @name + '%' " + "ORDER BY Name"; cmd.Connection = con; cmd.Parameters.AddWithValue("@name", txtSearchInventory.Text); DataTable dt = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(dt); GridViewInventory.DataSource = dt; GridViewInventory.DataBind(); con.Close(); }
//--------------------------------Datagrid view binding method---------------------------------------------------------// public void DatagridBind(List <InventoryCatalogue> bList) { GridViewInventory.DataSource = bList; Session["list"] = bList; GridViewInventory.DataBind(); }