string sql = string.Format("select distinct(T_NUMBER),T_UNIT||T_ADDRESS as T_ADDRESS from test3");
DbCommand cmd = db.GetSqlStringCommand(sql);
DataSet ds = db.ExecuteDataSet(cmd);这个走到DataSet 就卡住走不下去了。开始以为是SQL语句不支持,把语句减少到select distinct(T_NUMBER)from test3 还是下不去
string sql = string.Format("select distinct(Y_ClASS) from test1 where Y_ClASS!=' '");
DbCommand cmd = db.GetSqlStringCommand(sql);
DataSet ds = db.ExecuteDataSet(cmd);
这个正常往下走了,想不通
DbCommand cmd = db.GetSqlStringCommand(sql);
DataSet ds = db.ExecuteDataSet(cmd);这个走到DataSet 就卡住走不下去了。开始以为是SQL语句不支持,把语句减少到select distinct(T_NUMBER)from test3 还是下不去
string sql = string.Format("select distinct(Y_ClASS) from test1 where Y_ClASS!=' '");
DbCommand cmd = db.GetSqlStringCommand(sql);
DataSet ds = db.ExecuteDataSet(cmd);
这个正常往下走了,想不通
就像group by T_NUMBER 一样的