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