数据库表里有7条记录，却只显示出来1条,程序异常在哪呢
日期：2014-05-18 浏览次数：20461 次
数据库表里有7条记录，却只显示出来1条,程序错误在哪呢?求助
程序代码如下:
<%@page language= "C# " %>
<%@import namespace= "System.Data "%>
<%@import namespace= "System.Data.SqlClient "%>
<%@import namespace= "System.Data.OleDb "%>
<html>
<script language= "C# " runat=server>
void page_load(object serder,EventArgs e)
{
OleDbConnection oleconnection=new OleDbConnection( "provider=SQLOLEDB;database=chapter;user id=sa ");
OleDbCommand olecommand=new OleDbCommand();
OleDbDataReader oledatareader;
oleconnection.Open();
olecommand.Connection=oleconnection;
olecommand.CommandText= "select * from student ";
oledatareader=olecommand.ExecuteReader();
do
{
oledatareader.Read();
labcontext.Text+=oledatareader.GetString(0)+ " ";
labcontext.Text+=oledatareader.GetString(1)+ " ";
labcontext.Text+=oledatareader.GetInt32(2)+ " ";
labcontext.Text+=oledatareader.GetString(3)+ " "+ " <br> ";
}
while(oledatareader.NextResult());
olecommand=null;
oleconnection.Close();
oleconnection=null;
labcontext.Text+= "查找成功 ";
}
</script>
<body>
<form runat=server>
<asp:label id=labcontext runat=server /> <br>
</form>
</body>
</html>
已经在sql2000中建了一个名为chapter的数据库,里面有表student内容如下:
studentid name age address
97070701 kang 24 tianjin
97070702 li 21 shanghai
97070703 wang 20 beijing
程序代码如下:
<%@page language= "C# " %>
<%@import namespace= "System.Data "%>
<%@import namespace= "System.Data.SqlClient "%>
<%@import namespace= "System.Data.OleDb "%>
<html>
<script language= "C# " runat=server>
void page_load(object serder,EventArgs e)
{
OleDbConnection oleconnection=new OleDbConnection( "provider=SQLOLEDB;database=chapter;user id=sa ");
OleDbCommand olecommand=new OleDbCommand();
OleDbDataReader oledatareader;
oleconnection.Open();
olecommand.Connection=oleconnection;
olecommand.CommandText= "select * from student ";
oledatareader=olecommand.ExecuteReader();
do
{
oledatareader.Read();
labcontext.Text+=oledatareader.GetString(0)+ " ";
labcontext.Text+=oledatareader.GetString(1)+ " ";
labcontext.Text+=oledatareader.GetInt32(2)+ " ";
labcontext.Text+=oledatareader.GetString(3)+ " "+ " <br> ";
}
while(oledatareader.NextResult());
olecommand=null;
oleconnection.Close();
oleconnection=null;
labcontext.Text+= "查找成功 ";
}
</script>
<body>
<form runat=server>
<asp:label id=labcontext runat=server /> <br>
</form>
</body>
</html>
已经在sql2000中建了一个名为chapter的数据库,里面有表student内容如下:
studentid name age address
97070701 kang 24 tianjin
97070702 li 21 shanghai
97070703 wang 20 beijing
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
