全部
.NET Framework
ASP
Web Services
.NET互联网桌面应用
VB
图表区
分析与设计
组件/控件开发
AppLauncher
问答

asp.net中判断书库为空和asp一样？？

NetFire 2002-11-29 03:09:27

我看见framework.net文档中这样做，代码如下——

-----------------------------------
dim objConn, rs, sqlstr
sqlstr="SELECT * FROM Employees;"
objConn = Server.CreateObject("ADODB.Connection") ' Set removed.
objConn.Open("DSN=TEST") ' Parentheses added.
rs = objConn.execute(sqlstr) ' Set statement removed.
Response.Write("ADO Test")

if rs.BOF and rs.EOF then ' Query didn't return any records.
Response.Write("No Records")
else
...........
-----------------------------------

.net不会这样做哦，大家指教一二！

...全文

8 点赞收藏 6

写回复

6 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

117hn 2002-11-29

将查询到的结果保存到变量中，在判断变量是否为空

回复赞

NetFire 2002-11-29

oReader.Read()返回空？

回复赞

chinchy 2002-11-29

System.Data.SqlClient.SqlConnection oCnn;
System.Data.SqlClient.SqlCommand oCmd;
System.Data.SqlClient.SqlDataReader oReader;

string sSQL;
string sCnnString;
sCnnString="server=xxx;uid=sa;pwd=;database=northwind;";
sSQL="select categoryid, categoryname from categories";
oCnn=new System.Data.SqlClient.SqlConnection(sCnnString);
oCmd=new System.Data.SqlClient.SqlCommand(sSQL,oCnn);
oCnn.Open();
oReader=oCmd.ExecuteReader();
if(oReader.Read())
{
//ok
}
else
{
}
oReader.Close();
oCnn.Close();

回复赞

NetFire 2002-11-29

我明白了，刚才文档内容没有看完，大家看看下面的三段代码，也许就明白了

-----------------------------------
下面示例中的第一个代码块对于某类 ASP 应用程序是很典型的，该类应用程序使用 ADO 读取和操作从单个 SQL 查询返回的记录集。它使用 ADO Recordset 对象读取从用 Microsoft Access 提供的 Northwind 示例数据库返回的数据记录。这些代码将包含在具有 .asp 文件扩展名的文件中。

[Visual Basic]
<%@LANGUAGE=VBSCRIPT%>
<!
This ASP example uses ADO to read records from a database and print two
fields from all returned records to an ASP page. Connection to the Northwind database is through an ODBC system data source (DSN).
>
<html>
<body>
<%
dim ADOconn, ADOrs, sqlstr
sqlstr="SELECT * FROM Employees;"
set ADOconn = Server.CreateObject("ADODB.Connection")
ADOconn.Open "DSN = Test"
set ADOrs = ADOconn.execute(sqlstr)
if ADOrs.BOF and ADOrs.EOF then ' Query didn't return any records.
Response.Write("No Records.")
else
ADOrs.MoveFirst
Do While Not ADOrs.EOF
Response.Write(ADOrs("FirstName") & " " _
& ADOrs("LastName") & " ")
ADOrs.MoveNext
Loop
Response.Write("End of data.")
end if
ADOrs.close
set ADOrs = nothing
%>
</body>
</html>
下面的示例阐释将前面示例转换为 ASP.NET 应用程序所需的最低程度的更改。为了符合新的 Visual Basic 语法，大多数的更改都是必要的。此文件可以用 .aspx 文件扩展名重命名，并且将与 ASP.NET 一起运行。修改后的代码行以粗体显示。注意，在第一行上添加了具有 aspcompat=true 属性的 <%@ Page > 指令。

[Visual Basic]
<%@Page aspcompat=true Language = VB%>
<!
This example uses ADO to read records from a database and print two
fields from all records in the database to an ASP.NET page.
The database is located on the server and connection is through an ODBC system data source (DSN).
>
<html>
<body>
<%
dim objConn, rs, sqlstr
sqlstr="SELECT * FROM Employees;"
objConn = Server.CreateObject("ADODB.Connection") ' Set removed.
objConn.Open("DSN=TEST") ' Parentheses added.
rs = objConn.execute(sqlstr) ' Set statement removed.
Response.Write("ADO Test")

if rs.BOF and rs.EOF then ' Query didn't return any records.
Response.Write("No Records")
else
rs.MoveFirst
Do While Not rs.EOF
' Specify value property.
Response.Write(rs("FirstName").value _
& " " & rs("LastName").value & " ")
rs.MoveNext
Loop
Response.Write("End of data")
end if
rs.close
rs = nothing ' Set statement removed.
%>
下一个示例是一个 ASP.NET 应用程序，该程序使用 ADO.NET 从与前面示例相同的 Northwind 数据库读取记录。这些代码生成的输出等效于前面示例的输出，而且已被修改以符合 ASP.NET 代码块约定。

该示例创建一个 ADO.NET DataSet 对象，在此情况下此对象包含一个数据表，而该数据表的使用方式与 ADO 记录集的使用方式几乎相同。请注意，数据集可以由一个或多个构成内存驻留数据库的 DataTables、DataRelations 和 Constraints 的集合组成，因此 ADO.NET 数据集比 ADO 记录集灵活得多。

为了使用 ADO.NET，需要导入 System.Data 和 System.Data.OleDb 命名空间。如果数据源是 SQL Server 数据库，则导入 System.Data.SqlClient 命名空间而不是 System.Data.OleDb。

[Visual Basic]
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<!
This example uses ADO.NET to read records from a database and print two
fields from all returned records to an ASP.NET page. The database
is located on the local server.
>
<html>
<Script Language=VB Runat=Server>
Sub Page_Load(Sender As Object, e As EventArgs)
Dim MyConnection As OleDbConnection
Dim MyCommand As OleDbDataAdapter
dim MyDataset As DataSet
dim MyTable As DataTable
dim loop1, numrows As Integer
dim sqlstr As String

sqlstr = "SELECT * FROM Employees;"

' Create a connection to the data source.
MyConnection = New OleDbConnection("Provider=SQLOLEDB;" _
& "server=localhost;"Integrated Security=SSPI;" _
& "Initial Catalog=Northwind")

' Create a Command object with the SQL statement.
MyCommand = New OleDbDataAdapter(sqlstr, MyConnection)

' Fill a DataSet with data returned from the database.
MyDataset = New DataSet
MyCommand.Fill(MyDataset)

' Create a new DataTable object and assign to it
' the new table in the Tables collection.
MyTable = New DataTable
MyTable = MyDataset.Tables(0)
' Find how many rows are in the Rows collection
' of the new DataTable object.
numrows = MyTable.Rows.Count
If numrows = 0 then
Response.Write("No records.")
Else
Response.Write("" & Cstr(numrows) & " records found.")
For loop1 = 0 To numrows - 1
' Print the values of the two columns in the Columns
' collection for each row.
Response.Write(MyTable.Rows(loop1).Item("FirstName") _
& " " & MyTable.Rows(loop1).Item("LastName") & " ")
Next loop1
End If
Response.Write("End of data.")
End Sub
</Script>
</html>

-----------------------------------

回复赞