Example #1
0
    private void dataBind()
    {
        SqlDataSource1.SelectParameters.Clear();
        if (PatIDSearch.Text == "" && TextBoxtiltleSearch.Text == "")
        {
            SqlDataSource1.SelectCommand = " select p.ID,p.Title,p.Entry_Status,s.StatusName as Filling_Status from Patent_Data p,Patent_Status s where p.Filing_Status=s.Id and p.Filing_Status='GRN'";
        }
        else if (PatIDSearch.Text != "" && TextBoxtiltleSearch.Text == "")
        {
            SqlDataSource1.SelectCommand = " select p.ID,p.Title,p.Entry_Status,s.StatusName as Filling_Status from Patent_Data p,Patent_Status s where p.Filing_Status=s.Id and p.ID  LIKE '%'+@ID+'%'  and p.Filing_Status='GRN' ";
            SqlDataSource1.SelectParameters.Add("ID", PatIDSearch.Text.Trim());
        }

        else if (PatIDSearch.Text == "" && TextBoxtiltleSearch.Text != "")
        {
            SqlDataSource1.SelectCommand = "  select p.ID,p.Title,p.Entry_Status,s.StatusName as Filling_Status from Patent_Data p,Patent_Status s where p.Filing_Status=s.Id and p.Title  LIKE  '%'+@Title+'%' and p.Filing_Status='GRN' ";
            SqlDataSource1.SelectParameters.Add("Title", TextBoxtiltleSearch.Text.Trim());
        }
        else
        {
            SqlDataSource1.SelectCommand = " select p.ID,p.Title,p.Entry_Status,s.StatusName as Filling_Status from Patent_Data p,Patent_Status s where p.Filing_Status=s.Id and p.ID  LIKE '%'+@ID+'%'  and p.Title  LIKE  '%'+@Title+'%' and p.Filing_Status='GRN' ";
            SqlDataSource1.SelectParameters.Add("ID", PatIDSearch.Text.Trim());
            SqlDataSource1.SelectParameters.Add("Title", TextBoxtiltleSearch.Text.Trim());
        }
        GridViewSearchPatent.DataBind();
        SqlDataSource1.DataBind();
        GridViewSearchPatent.Visible = true;
    }
Example #2
0
 protected void GridViewSearchPatent_PageIndexChanging(object sender, GridViewPageEventArgs e)
 {
     GridViewSearchPatent.PageIndex = e.NewPageIndex;
     GridViewSearchPatent.DataBind();
     dataBind();
 }