protected void ibtnReset_Click(object sender, ImageClickEventArgs e)
{
this.serialnum.Value = "";
string sqlstr = "";
sqlstr += Session["query"].ToString();
string com = Request.QueryString["com"].ToString();
string sale = Request.QueryString["sale"].ToString();
sqlstr += " and company = " + Convert.ToInt32(com) + " and salesman = " + sale;// + " and " + type + " is not null"
Data data = new Data();
DataSet ds = data.DataPage("View_PolicyAndBudget", "Id", "*", sqlstr, "Id", true, 10, 5, pages);
Rppolicy.DataSource = ds;
Rppolicy.DataBind();
}
private void binddata()
{
//string type = Request.QueryString["type"].ToString();
string sqlstr = "";
sqlstr += Session["query"].ToString();
string com = Request.QueryString["com"].ToString();
string sale = Request.QueryString["sale"].ToString();
sqlstr += " and company = " + Convert.ToInt32(com) + " and salesman = " + sale + " and auditstatus=" + "'04'";// + " and " + type + " is not null"
Data data = new Data();
DataSet ds = data.DataPage("View_PolicyAndBudget", "Id", "*", sqlstr, "Id", true, 10, 5, pages);
Rppolicy.DataSource = ds;
Rppolicy.DataBind();
}
