protected void AddInventoryGridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { AddInventoryGridView.PageIndex = e.NewPageIndex; string mainconn = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); sqlconn.Open(); SqlCommand sqlcomm = new SqlCommand(); string sqlquery = "Select *" + "From[UzimaDrug]"; sqlcomm.Parameters.AddWithValue("DrugName", AddInventorySearch.Text); sqlcomm.CommandText = sqlquery; sqlcomm.Connection = sqlconn; DataTable dt = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter(sqlcomm); sda.Fill(dt); AddInventoryGridView.DataSource = dt; AddInventoryGridView.DataBind(); }
protected void InventorySearchBtn_Click(object sender, EventArgs e) { AddInventoryGridView.Visible = true; string mainconn = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); sqlconn.Open(); SqlCommand sqlcomm = new SqlCommand(); string sqlquery = "Select *" + "From[UzimaDrug]" + "Where [DrugName] like '%'+@DrugName+'%'"; sqlcomm.Parameters.AddWithValue("DrugName", AddInventorySearch.Text); sqlcomm.CommandText = sqlquery; sqlcomm.Connection = sqlconn; DataTable dt = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter(sqlcomm); sda.Fill(dt); AddInventoryGridView.DataSource = dt; AddInventoryGridView.DataBind(); }
protected void OnPaging(object sender, GridViewPageEventArgs e) { AddInventoryGridView.PageIndex = e.NewPageIndex; AddInventoryGridView.DataBind(); }