private void MenuItem_Clicked(object sender, EventArgs e) { var Search = (sender as MenuItem).CommandParameter as Search; Service.DeleteSearch(Search.Id); Searchlist.EndRefresh(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { String a = Request.QueryString["search"]; SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SalgDBConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand("SELECT * FROM Products WHERE ProductName LIKE'%" + a + "%'OR Description LIKE '%" + a + "%'", con); if (a != null) { con.Open(); SqlDataReader dr = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(dr); Searchlist.DataSource = dt; Searchlist.DataBind(); con.Close(); } } }
//Retrieve list of all searches by specific user public List <Searchlist> retrieve_searches_db(string userid) { var results = new List <Searchlist>(); var query = "SELECT QueryId, SearchTitle, Date, PeakListFileAddress FROM proteomics.query where UserId='" + userid + "';"; if (!OpenConnection()) { return(results); } try { var cmd = new MySqlCommand(query, _connection); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var temp = new Searchlist { Qid = reader["QueryId"].ToString(), Title = reader["SearchTitle"].ToString(), Date = reader["Date"].ToString(), File = reader["PeakListFileAddress"].ToString() }; results.Add(temp); } } _connection.Close(); } catch (Exception e) { Debug.WriteLine(e.Message); } return(results); }