紧急求助SqlDataReader读取数据出错!!!!!!!
我用这段代码
while(ticketReader.Read()){
sp1str = sp1str + "<TR>";
sp1str = sp1str + "<TD height='25'><div align='center'>"+ticketReader.GetString(1)+"-"+ticketReader.GetString(2)+"</div></TD>";
sp1str = sp1str + "<TD><div align='center'>"+ticketReader.GetString(3)+"</div></TD>";
sp1str = sp1str + "<TD><div align='center'>"+ticketReader.GetString(10)+"</div></TD>";
sp1str = sp1str + "<TD><div align='center'>"+ticketReader.GetString(11)+"</div></TD>";
sp1str = sp1str + "<TD><div align='center'>"+ticketReader.GetString(4)+"</div></TD>";
sp1str = sp1str + "<TD><div align='center'>"+ticketReader.GetString(5)+"</div></TD>";
sp1str = sp1str + "<TD><div align='center'>"+ticketReader.GetString(6)+"</div></TD>";
sp1str = sp1str + "<TD><div align='center'>"+ticketReader.GetString(7)+"</div></TD>";
sp1str = sp1str + "<TD><div align='center'>"+ticketReader.GetString(9)+"</div></TD>";
sp1str = sp1str + "</TR>";
}
其他的都可以,就是ticketReader.GetString(10)ticketReader.GetString(11)出现错误:
异常详细信息: System.IndexOutOfRangeException: 索引超出了数组界限。
源错误:
行 189：sp3str = sp3str + "<TD height='25'><div align='center'>"+ticketReader3.GetString(1)+"-"+ticketReader3.GetString(2)+"</div></TD>";
行 190：sp3str = sp3str + "<TD><div align='center'>"+ticketReader3.GetString(3)+"</div></TD>";
行 191：sp3str = sp3str + "<TD><div align='center'>"+ticketReader3.GetString(10)+"</div></TD>";
行 192：sp3str = sp3str + "<TD><div align='center'>"+ticketReader3.GetString(11)+"</div></TD>";
行 193：sp3str = sp3str + "<TD><div align='center'>"+ticketReader3.GetString(4)+"</div></TD>";
请大家指教一下
问题点数：20、回复次数：6Top
1 楼mytail001（Never Give Up!）回复于 2006-03-01 13:59:54 得分 0
没碰到过，帮顶下，Top
2 楼perilla（紫苏）回复于 2006-03-01 14:00:18 得分 0
索引超出了数组界限。ticketReader.GetString(11)不存在吧。
ticketReader.GetString(0）才表示第1个字段。ticketReader.GetString(11)应该指的是12个字段Top
3 楼feidaoxiaoli（★★★★★）回复于 2006-03-01 14:03:10 得分 0
警报解除了,我的sql写错了.不好意思新手!
perilla(紫苏) 你说对了!Top
4 楼luck0235（风平浪静时人人都能掌舵）回复于 2006-03-01 14:07:08 得分 0
如上，数组应该是从索引0开始的吧。Top
5 楼songxiaozhao（雨朋）回复于 2006-03-01 14:10:17 得分 0
C#
索引都是从0开始的吧
Top
6 楼wutian789（天涯）回复于 2006-03-01 15:06:57 得分 0
upTop
