protected void grdResult_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e) { string query = "DELETE FROM Books WHERE Id = @Id"; Dictionary <string, object> parametters = new Dictionary <string, object>(); parametters.Add("Id", e.Keys[0]); MySqlProvider.ExecuteSqlQueryReturnValue(query, parametters, result => grdResultFill()); }
private void grdResultFill() { string query = "SELECT * FROM Books"; MySqlProvider.ExecuteSqlQueryReturnValue(query, null, delegate(MySqlDataReader reader) { grdResult.DataSource = reader; grdResult.DataBind(); }); }
protected void btnSearch_Click(object sender, EventArgs e) { string query = "SELECT * FROM books WHERE LOCATE (@SearchOption, Title)"; Dictionary <string, object> parametters = new Dictionary <string, object>(); parametters.Add("SearchOption", txtSearch.Text); MySqlProvider.ExecuteSqlQueryReturnValue(query, parametters, delegate(MySqlDataReader reader) { grdResult.DataSource = reader; grdResult.DataBind(); }); }