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]); SqLiteProvider.ExecuteSqlQueryReturnValue(query, parametters, result => grdResultFill()); }
private void grdResultFill() { string query = "SELECT * FROM Books"; SqLiteProvider.ExecuteSqlQueryReturnValue(query, null, delegate(SQLiteDataReader reader) { grdResult.DataSource = reader; grdResult.DataBind(); }); }
protected void btnSearch_Click(object sender, EventArgs e) { string query = "SELECT * FROM books WHERE CHARINDEX (@SearchOption, Title)"; Dictionary <string, object> parametters = new Dictionary <string, object>(); parametters.Add("SearchOption", txtSearch.Text); SqLiteProvider.ExecuteSqlQueryReturnValue(query, parametters, delegate(SQLiteDataReader reader) { grdResult.DataSource = reader; grdResult.DataBind(); }); }