private string GetBillId() { m_sBillId = ""; DataTable dtSel = new DataTable(); dtSel = grdDemand.DataSource as DataTable; DataView dview = new DataView(dtSel) { RowFilter = "Sel=" + true + "" }; DataTable dt = new DataTable(); dt = dview.ToTable(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { int iLeadId = Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[i]["LeadId"], CommFun.datatypes.vartypenumeric)); int iFlatId = Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[i]["FlatId"], CommFun.datatypes.vartypenumeric)); int iSortOrder = Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[i]["SortOrder"], CommFun.datatypes.vartypenumeric)); DataView dv = new DataView(dtSel) { RowFilter = "LeadId=" + iLeadId + " AND FlatId=" + iFlatId + " AND SortOrder<=" + iSortOrder + "" }; DataTable dtFilter = new DataTable(); dtFilter = dv.ToTable(); if (dtFilter != null) { for (int k = 0; k < dtFilter.Rows.Count; k++) { if (m_sBillId == "") { m_sBillId = String.Format("{0}", dtFilter.Rows[k]["PBillId"]); } else { m_sBillId = String.Format("{0},{1}", m_sBillId, dtFilter.Rows[k]["PBillId"]); } } m_sBillId = m_sBillId.TrimEnd(','); if (m_sBillId == "") { m_sBillId = "0"; } //Insert into Temp Table ProgBillBL.InsertDLDate(m_sLeadId, m_sBillId, dtFilter); } } } return(m_sBillId); }