各位大哥大姐,帮小弟看看下面这个错误吧,小弟十分感谢,很急呀,搞了一天拉,不知道怎么回事,我是个新手,请多指教,谢谢!
Compiler Error Message: BC30188: Declaration expected.Source Error: Line 7: dim oConn as SQLConnection
Line 8: dim oComm as SQLCommand
Line 9: strConn="server=localhost;uid=wanggang;pwd=12678;database=book" (这一行有错)
Line 10: strComm="insert into Admin(adminname,adminpass)Values('xiaohua','1234567')"
Line 11: oConn=new SQLConnection(strConn)
所有的程序如下:
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Import Namespace="System.Data" %>
<%@ Import NameSpace="System.Data.SQLClient" %>
<script language="vb" runat="server">
dim strConn as string
dim strComm as string
dim oConn as SQLConnection
dim oComm as SQLCommand
strConn="server=localhost;uid=wanggang;pwd=12678;database=book"
strComm="insert into Admin(adminname,adminpass)Values('xiaohua','1234567')"
oConn=new SQLConnection(strConn)
oComm=new SQLCommand(strComm,oConn)
Try
oConn.open()
Message.InnerHtml="连接数据库成功!"
oComm.ExecuteNonQuery()
Catch myException as Exception
Message.InnerHtml="靠,出错拉!"
Finally
oConn.close()
end Try</script>
Compiler Error Message: BC30188: Declaration expected.Source Error: Line 7: dim oConn as SQLConnection
Line 8: dim oComm as SQLCommand
Line 9: strConn="server=localhost;uid=wanggang;pwd=12678;database=book" (这一行有错)
Line 10: strComm="insert into Admin(adminname,adminpass)Values('xiaohua','1234567')"
Line 11: oConn=new SQLConnection(strConn)
所有的程序如下:
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Import Namespace="System.Data" %>
<%@ Import NameSpace="System.Data.SQLClient" %>
<script language="vb" runat="server">
dim strConn as string
dim strComm as string
dim oConn as SQLConnection
dim oComm as SQLCommand
strConn="server=localhost;uid=wanggang;pwd=12678;database=book"
strComm="insert into Admin(adminname,adminpass)Values('xiaohua','1234567')"
oConn=new SQLConnection(strConn)
oComm=new SQLCommand(strComm,oConn)
Try
oConn.open()
Message.InnerHtml="连接数据库成功!"
oComm.ExecuteNonQuery()
Catch myException as Exception
Message.InnerHtml="靠,出错拉!"
Finally
oConn.close()
end Try</script>
解决方案 »
- 关于sql proc 里的一个问题
- 求更新gridview的一段代码?
- ASP.net在什么文件中定义全局变量
- ■■如何在一个大项目中建几个项目呢?(.net1.1)
- 介绍一个很强大的购物系统
- ■■第一次做数据库连接,不知如何实现ASP的rs("XX")■■
- 上海著名的.NET平台网站开发商隆重推出近期作品
- 页面中怎样判断一行textbox为空?急!
- vb.net语言如何能够打开一个新的窗口?response.redirect只能在当前窗口中打开新一页。
- 为什么有些页面不刷新,Js就不起作用
- 超级郁闷关于dataReader的问题!!真搞不懂问题出在哪里了!!
- 如何固定DataGrid里显示的字数,后面用...代替
不过感觉应该这样写:
string strConn="......"
应该就是没声明变量
是不是有问题,表里面的数据vacr的值是不是小了。