拆分出第一个字段:
string sql = "select distinct substring(polt_id,1,charindex('#',polt_id)-1) as CANTON_Name ";
sql += " from ( select distinct polt_id from ShougeInfo)as tb";
拆分出第二哥字段:
string sql = "select distinct substring(polt_id,charindex('#',polt_id)+1,len(polt_id)-charindex('#',polt_id)) as Polt_id ";
sql += " from ( select distinct polt_id from ShougeInfo) as tb where substring(polt_id,1,charindex('#',polt_id)-1) ='" + ddl_Area.SelectedValue + "'";