帮小弟看看下面这个错误吧,小弟十分感谢,很急呀,搞了一天拉,不知道怎么回事,我是个新手,请多指教,谢谢!
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>
解决方案 »
- ########## 重装VS2005后, 属性窗口在代码状态下什么都没有, 一些工具ILDASM 都不出现在菜单上了,请教
- MSDTC 分布式事务错误:[COMException (0x8004d00e): 此事务已明地或暗地被确认或终止 (异常来自 HRESULT:0x8004D00E)]
- 超连接列的显示问题
- 英文系统下的中文乱码问题
- dropdownlist控件的使用问题(急等解决)
- datalist的显示问题
- arraylist 的 count属性无效?
- 这样的需求如何解决(在线等)
- 关于datareader的问题!!!!!!!!!!!!!!!
- 我们是选择dot.net还是j2ee ? 请大家讨论一下dot.net和j2ee各自的优缺点?
- 分析器错误信息: 未能加载类型
- SqlDataSource编辑修改数据的问题
如果用户名和密码不错的话,换下面的看看
strConn="server=(local);uid=wanggang;pwd=12678;database=book"
或者
strConn="server=.;uid=wanggang;pwd=12678;database=book"
或者
strConn="server=192.168.0.88;uid=wanggang;pwd=12678;database=book" //192.168.0.88是IP 地址
不过感觉应该这样写:
string strConn="......"
应该就是没声明变量