private void BindData(string strOrder)
    {
        DataSet dstData = new DataSet();

        objSpare.FromDate = txtFromDate.Text.ToString();
        objSpare.ToDate   = txtToDate.Text.ToString();
        if (ddlRegion.SelectedIndex != 0)
        {
            objSpare.Region_Sno = int.Parse(ddlRegion.SelectedValue.ToString());
        }
        if (ddlBranch.SelectedIndex != 0)
        {
            objSpare.Branch_SNo = int.Parse(ddlBranch.SelectedValue.ToString());
        }
        if (ddlProductDivison.SelectedIndex != 0)
        {
            objSpare.Unit_SNo = int.Parse(ddlProductDivison.SelectedValue.ToString());
        }
        //if (ddlCallStage.SelectedIndex != 0)
        //    objSpare.CallStage = ddlCallStage.SelectedItem.Text.ToString();
        //if (ddlCallStatus.SelectedIndex != 0)
        //    objSpare.StatusID = ddlCallStatus.SelectedValue.ToString();
        // dstData = objCommonClass.BindDataGrid(gvComm, "uspMisDetail", true, sqlParamSrh, true);
        if (ddlSpareStatus.SelectedIndex != 0)
        {
            objSpare.Spare_Status = ddlSpareStatus.SelectedValue;
        }
        dstData          = objSpare.BindData(gvComm);
        lblRowCount.Text = dstData.Tables[0].Rows.Count.ToString();
        DataView dvSource = default(DataView);

        dvSource      = dstData.Tables[0].DefaultView;
        dvSource.Sort = strOrder;

        if ((dstData != null))
        {
            gvComm.DataSource = dvSource;
            gvComm.DataBind();
        }
        dstData = null;
        dvSource.Dispose();
        dvSource = null;
    }