求救,asp.net(vb)编译出错,请大家帮忙改正!!!!!
ROSUN 2005-03-21 04:34:04 <%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<Script Languate="VB" Runat="Server">
'strSQL 为 SQL 语句,FileName 为数据库文件名,TableName 为数据表名称。
Function CreateDataSet(strSQL As String, FileName As String, TableName As String) As DataSet
Dim ConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath(FileName)
Dim objCmd As New OleDbDataAdapter(strSQL, ConnString)
Dim DS As New DataSet()
objCmd.Fill(DS, TableName)
CreateDataSet = DS
End Function
</Script>
<Script Language="VB" Runat="Server">
'BindList 过程用来指定数据源,并连接到 DataList 控件
Sub BindList()
Dim strSQL As String = "Select * From 通讯簿"
myDataList.DataSource = CreateDataSet(strSQL, "Address.mdb", "通讯簿")
myDataList.DataBind()
End Sub
Sub Page_Load(sender As Object, e As Eventargs)
If Not IsPostBack Then BindList()
End Sub
'用来进入数据编辑模式
Sub DataList_EditCommand(sender As Object, e As DataListCommandEventArgs)
myDataList.EditItemIndex = e.Item.ItemIndex
BindList()
End Sub
'用来离开数据编辑模式
Sub DataList_CancelCommand(sender As Object, e As DataListCommandEventArgs)
myDataList.EditItemIndex = -1
BindList()
End Sub
'用来执行 SQL 语句,如 Update 及 Delete。
Sub ExecuteSQL(strSQL As String)
Dim objConn As New OleDbConnection()
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("Address.mdb")
objConn.Open()
Dim objCmd As New OleDbCOMMAND(strSQL,objConn)
OBJCMD.EXECUTENONQUERY .......................................................................'这里就是出现异常的语句
End Sub
'用来删除数据
Sub DataList_DeleteCommand(sender As Object, e As DataListCommandEventArgs)
Dim strSQL As String = "Delete From 通讯簿 Where " & _
myDataList.DataKeyField & "=" & myDataList.DataKeys(e.Item.ItemIndex)
ExecuteSQL(strSQL)
myDataList.EditItemIndex = -1
BindList()
End Sub
'用来更新数据
Sub DataList_UpdateCommand(sender As Object, e As DataListCommandEventArgs)
Dim Birthday As String = CType(e.Item.FindControl("Birthday"), TextBox).Text
Dim Tel As String = Ctype(e.Item.FindControl("Tel"), TextBox).Text
Dim UpdateDate As DateTime = DateTime.Now.Date()
Dim strSQL As String = "Update 通讯簿 Set 生日='" & CDate(Birthday) & _
"', 电话='" & Tel & "' Where " & myDataList.DataKeyField & "=" & _
myDataList.DataKeys(e.Item.ItemIndex)
ExecuteSQL(strSQL)
myDataList.EditItemIndex = -1
BindList()
End Sub
</Script>
<Html>
<Body>
<H1 Align="Center">通讯簿管理系统</H1>
<Form Runat="Server">
<Asp:DataList Runat="Server" Id="myDataList" CellPadding="3" Width="500"
HorizontalAlign="Center" OnEditCommand="DataList_EditCommand"
OnUpdateCommand="DataList_UpdateCommand" OnDeleteCommand="DataList_DeleteCommand"
OnCancelCommand="DataList_CancelCommand" DataKeyField="编号"
ExtractTemplateRows="True" Border="1" BorderColor="Blue" GridLines="Horizontal">
<HeaderTemplate>
<Asp:Table Runat="Server" Width="500">
<Asp:TableRow Runat="Server">
<Asp:TableCell Runat="Server" Width="50">
姓名
</Asp:TableCell>
<Asp:TableCell Runat="Server" Width="70">
生日
</Asp:TableCell>
<Asp:TableCell Runat="Server" Width="100">
电话
</Asp:TableCell>
<Asp:TableCell Runat="Server" Width="80">
功能
</Asp:TableCell>
</Asp:TableRow>
</Asp:Table>
</HeaderTemplate>
<ItemTemplate>
<Asp:Table Runat="Server" Width="500">
<Asp:TableRow Runat="Server" HorizontalAlign="Center">
<Asp:TableCell Runat="Server">
<%# Container.DataItem("姓名") %>
</Asp:TableCell>
<Asp:TableCell Runat="Server">
<%# Container.DataItem("生日").ToShortDateString %>
</Asp:TableCell>
<Asp:TableCell Runat="Server">
<%# Container.DataItem("电话") %>
</Asp:TableCell>
<Asp:TableCell Runat="Server">
<Asp:LinkButton Runat="Server" Text="编辑" CommandName="Edit"/>
</Asp:TableCell>
</Asp:TableRow>
</Asp:Table>
</ItemTemplate>
<EditItemTemplate>
<Asp:Table Runat="Server" Width="500">
<Asp:TableRow Runat="Server" HorizontalAlign="Center">
<Asp:TableCell Runat="Server">
<%# Container.DataItem("姓名") %>
</Asp:TableCell>
<Asp:TableCell Runat="Server">
<Asp:TextBox Runat="Server" Id="Birthday" Width="90"
Text='<%# Container.DataItem("生日").ToShortDateString %>' />
</Asp:TableCell>
<Asp:TableCell Runat="Server">
<Asp:TextBox Runat="Server" Id="Tel" Width="130"
Text='<%# Container.DataItem("电话") %>' />
</Asp:TableCell>
<Asp:TableCell Runat="Server">
<Asp:LinkButton Runat="Server" Width="18"
Text="更新" CommandName="Update" />
<Asp:LinkButton Runat="Server" Width="18"
Text="删除" CommandName="Delete" />
<Asp:LinkButton Runat="Server" Width="18"
Text="取消" CommandName="Cancel" />
</Asp:TableCell>
</Asp:TableRow>
</Asp:Table>
</EditItemTemplate>
<HeaderStyle HorizontalAlign="Center" BackColor="#66CCFF" ForeColor="Crimson" />
<ItemStyle BackColor="Moccasin" />
<EditItemStyle BackColor="Lavender" />
</Asp:DataList>
</Form>
</Body>
</Html>
注:数据库名叫"address.mdb",表名叫"通讯簿",里面有四个字段"编号,姓名,生日,电话"