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