Cận
12-07-2003, 11:38
Em đọc sách thấy người ta ghi như sau:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQL" %>
<script language="VB" runat="server">
Sub Page_Load(obj as Object, e as EventArgs)
dim myCommand as SQLCommand
dim myReader as SQLDataReader
dim sql as string
dim cnstr as string
sql="select * from MyTable"
cnstr="server=localhost; uid=;pwd=;database=MyDatabase"
myCommand=new SQLCommand(sql,cnstr)
myCommand.ActiveConnection.Open()
myCommand.Execute(myReader)
while myReader.read
.....
end while
End Sub
</script>
Nhưng mà khi chạy nó báo lỗi.
Em đang dùng .NET Framework version 1.1. Có bác nào biết thì nhớ chỉ em nhé. Em xin cảm ơn
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQL" %>
<script language="VB" runat="server">
Sub Page_Load(obj as Object, e as EventArgs)
dim myCommand as SQLCommand
dim myReader as SQLDataReader
dim sql as string
dim cnstr as string
sql="select * from MyTable"
cnstr="server=localhost; uid=;pwd=;database=MyDatabase"
myCommand=new SQLCommand(sql,cnstr)
myCommand.ActiveConnection.Open()
myCommand.Execute(myReader)
while myReader.read
.....
end while
End Sub
</script>
Nhưng mà khi chạy nó báo lỗi.
Em đang dùng .NET Framework version 1.1. Có bác nào biết thì nhớ chỉ em nhé. Em xin cảm ơn