UC知道怎么回事？页面上没有反应？
来源：百度知道 编辑：UC知道 时间：2024/05/01 09:07:50
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<script language="C#" runat="server">
void page_Load()
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=E:\zhangtianxing\zhangtianxing\zhangtianxing.mdb";
string strSQL = "select title,writer,print date,isbn from zhangtianxing";
string strRead = "";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand objCommand = new OleDbCommand(strSQL,objConnection);
OleDbDataReader objDataReader = null;
try
{
objConnection.Open();
objDataReader = objCommand.ExecuteReader();
while (objDataReader.Read() == true)
{
strRead += objDataReader["title"];
s
<%@ Import Namespace="System.Data.OleDb"%>
<script language="C#" runat="server">
void page_Load()
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=E:\zhangtianxing\zhangtianxing\zhangtianxing.mdb";
string strSQL = "select title,writer,print date,isbn from zhangtianxing";
string strRead = "";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand objCommand = new OleDbCommand(strSQL,objConnection);
OleDbDataReader objDataReader = null;
try
{
objConnection.Open();
objDataReader = objCommand.ExecuteReader();
while (objDataReader.Read() == true)
{
strRead += objDataReader["title"];
s
你使用的这个方式我不是很熟悉，不过你可以
response.write(strRead)
打印一下看 strRead 有没有值
单步跟踪下，看变量里有没有东西！
数据库是否连上！存储过程是否正确！
问题出在
select title,writer,print date,isbn from zhangtianxing
这一句,因为你的print date字段中的空格啊,我讨厌你们把字段里带空格或用中文,不过这种情况你可以把字段名用[]括起来,就是把上一句改成
select title,writer,[print date],isbn from zhangtianxing
还有,在调试时最好把
try
{
}
catch
{
}
这些注释掉这样才会知道啊儿错了啊,调试时用了try错了不会报错的啊,不是被try过去了吗？