一段添加记录的asp.net程序出错,请教.
nnh 2003-07-22 10:24:38 程序如下:
<%@ Page Language="VB" debug="true"%>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Page_Load(obj as object, e as eventargs)
dim objConn as new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=c:\inetpub\wwwroot\net\book2\6_3\test.mdb")
try
objConn.Open
dim Cmdstr as string
CmdStr="INSERT INTO user (name,age) Values ('china','26')"
dim cmd as Oledbcommand=new Oledbcommand(CmdStr,objconn)
cmd.ExecuteNonQuery()
status.text="<FONT COLOR='#CC0000'>Add data was sucessful!</FONT>"
catch
status.text="<FONT COLOR='#CC0000'>Add data was false!</FONT>"
finally
objConn.Close
end try
end sub
</script>
<html>
<body>
"Add a data"
<BR><BR>
<asp:label id="status" runat="server"/>
</body>
</html>
程序运行后,IE显示为:
"Add a data"
Add data was false!
记录没有添加成功,请问是那出错了??