Re: [問題] sql DISTINCT 的值如何存進陣列裡
※ 引述《akhu (wait)》之銘言：
: for (int j = 0; j < 100; j++)
: {
: sql = "SELECT DISTINCT Name FROM A";
: sdr = data.getRow(sql);
: sdr.Read();
: Array[j] = Convert.ToString(sdr["Name"].ToString());
: }
for (int j = 0; j < 100; j++)
{
sql = "SELECT DISTINCT Name FROM A";
sdr = data.getRow(sql);
while (sdr.Read())
{
sdr.Read();
Array[j] = Convert.ToString(sdr["Name"].ToString());
}
}
--
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 112.105.218.191
→
05/16 12:25, , 1F
05/16 12:25, 1F
推
05/16 12:40, , 2F
05/16 12:40, 2F
推
05/16 22:59, , 3F
05/16 22:59, 3F
→
05/17 10:40, , 4F
05/17 10:40, 4F
→
05/17 12:27, , 5F
05/17 12:27, 5F
→
05/17 12:28, , 6F
05/17 12:28, 6F
→
05/17 17:23, , 7F
05/17 17:23, 7F
→
05/17 17:38, , 8F
05/17 17:38, 8F
推
05/17 19:32, , 9F
05/17 19:32, 9F
推
05/19 02:08, , 10F
05/19 02:08, 10F
→
05/19 09:07, , 11F
05/19 09:07, 11F
→
05/19 17:34, , 12F
05/19 17:34, 12F
推
05/19 21:30, , 13F
05/19 21:30, 13F
→
05/20 07:06, , 14F
05/20 07:06, 14F
→
05/20 07:09, , 15F
05/20 07:09, 15F
→
05/20 15:49, , 16F
05/20 15:49, 16F
→
05/20 15:50, , 17F
05/20 15:50, 17F
→
05/20 15:50, , 18F
05/20 15:50, 18F
推
05/20 22:42, , 19F
05/20 22:42, 19F
→
05/21 07:40, , 20F
05/21 07:40, 20F
→
05/21 07:41, , 21F
05/21 07:41, 21F
推
05/23 16:44, , 22F
05/23 16:44, 22F
推
06/16 07:42, , 23F
06/16 07:42, 23F
討論串 (同標題文章)
C_Sharp 近期熱門文章
PTT數位生活區 即時熱門文章
