public static DataTable Get_ItemSubGroup_ByItemGroup(string IG_ID) { string strSqlString = ""; try { strSqlString = " Select 0 value,'--Select Sub Group--' Text,0 RSN " + " UNION ALL " + " Select ISG_ID ,Item_SubGroup,1 RSN " + " from M_AT_Mst_ItemSubGroup " + " WHERE Fk_IG_ID=" + IG_ID + " Order By RSN asc, Text asc "; return(MEF.DA_GetDataTable(strSqlString)); } catch (Exception ex) { throw new Exception(ex.Message); } }