//----------------------------------------------------------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();
}
