[問題] ACCESS資料庫讀取的問題
最近在學C#
我想要讀取某欄的最後一列,到底要怎麼寫呢
寫到這樣實在不知道怎麼寫了@@
OleDbConnection thisConnection = new
OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ConnDB.mdb;");
thisConnection.Open();
OleDbCommand thisCommand=thisConnection.CreateCommand();
thisCommand.CommandText = "SELECT * FROM GCenterLocation";
OleDbDataReader thisReader=thisCommand.ExecuteReader();
while (thisReader.Read())
{
MX = System.Convert.ToDouble(thisReader["AxisX"]);
MY = System.Convert.ToDouble(thisReader["AxisY"]);
}
thisReader.Close();
thisConnection.Close();
執行後只能讀到第一列,還是說datareader沒辦法做到??
我想要讀取該欄的最後一列,懇請各位高手指教 感謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 210.240.249.227
→
12/30 19:45, , 1F
12/30 19:45, 1F
推
12/30 20:19, , 2F
12/30 20:19, 2F
→
12/30 20:20, , 3F
12/30 20:20, 3F
→
12/30 20:24, , 4F
12/30 20:24, 4F
→
12/30 20:25, , 5F
12/30 20:25, 5F
→
12/30 20:26, , 6F
12/30 20:26, 6F
推
12/30 22:00, , 7F
12/30 22:00, 7F
→
12/30 22:01, , 8F
12/30 22:01, 8F
→
12/30 22:02, , 9F
12/30 22:02, 9F
→
12/30 22:04, , 10F
12/30 22:04, 10F
→
12/30 22:48, , 11F
12/30 22:48, 11F
→
12/30 22:49, , 12F
12/30 22:49, 12F
→
12/30 22:49, , 13F
12/30 22:49, 13F
討論串 (同標題文章)
完整討論串 (本文為第 1 之 2 篇):