asp.net连接sql server2005出现的问题！帮我看一看错误在哪儿？

asp.net连接sql server2005出现的问题！帮我看一看错误在哪儿？

senyo
senyo
等级:

发表于：2008-05-17 21:36:15 楼主

出现的错误如下：
“/myweb”应用程序中的服务器错误。
--------------------------------------------------------------------------------

无法打开登录所请求的数据库 "注册系统"。登录失败。
用户 'www' 登录失败。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.SqlClient.SqlException: 无法打开登录所请求的数据库 "注册系统"。登录失败。
用户 'www' 登录失败。

源错误:

行 48: connstr="server=(local);database=注册系统;uid=www;pwd=123456;"
行 49: sqlconn.connectionstring=connstr
行 50: sqlconn.open()
行 51: sqlcmd.connection=sqlconn
行 52: sqlcmd.commandtype=commandtype.text

源文件: E:\asp\220.aspx 行: 50

堆栈跟踪:

[SqlException (0x80131904): 无法打开登录所请求的数据库 "注册系统"。登录失败。
用户 'www' 登录失败。]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
ASP._220_aspx.insertyh(Object sender, EventArgs e) in E:\asp\220.aspx:50
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

另外网页的源码如下：

<%@ Page Language="VB" Debug="true" %>
<%@ import namespace="system.data" %>
<%@ import namespace="system.data.sqlclient" %>
<html>
<head>
<title>注册 </title>
<body>
<form name="form1" method="post" runat="server">
<center>
<asp:Label id="Label0" Runat="Server" font-size="Small">用户注册信息 </asp:Label>
<br> <br>
<asp:Label id="Label2" runat="server" font-size="Smaller">用户名： </asp:Label>
<asp:TextBox id="yhm" runat="server"> </asp:TextBox>*(这是必填的)  
</asp:RequiredFieldValidator>
<br> <br>
<asp:Label id="Label1" runat="server" font-size="Smaller">密码： </asp:Label>
<asp:TextBox id="mim" runat="server" textmode="password"> </asp:TextBox>*(这是必填的)  
<br> <br>
<asp:Label id="Label11" runat="server" font-size="Smaller">邮箱： </asp:Label>
<asp:TextBox id="yx" runat="server" > </asp:TextBox>
<br> <br>
<asp:Label id="Label4" runat="server" font-size="Smaller">性别： </asp:Label>
<asp:RadioButton id="xb" Checked="True" GroupName="Sex" Text="男" TextAlign="Right" Runat="Server" />
<asp:RadioButton id="xb1" Checked="False" GroupName="Sex" Text="女" TextAlign="Right" Runat="Server" />
<br> <br>
<asp:Label id="Label6" runat="server" font-size="Smaller">来自： </asp:Label>
<asp:DropDownList id="lz" Runat="Server">
<asp:ListItem value="beijing" selected="True">北京市 </asp:ListItem>
<asp:ListItem value="shanghai" selected="False">上海市 </asp:ListItem>
<asp:ListItem value="xianggang" selected="False">香港 </asp:ListItem>
<asp:ListItem value="tianjin" selected="False">天津市 </asp:ListItem>
<asp:ListItem value="nanjing" selected="False">南京市 </asp:ListItem>
<asp:ListItem value="jiangxi" selected="False">江西省 </asp:ListItem>
</asp:DropDownList>
<br> <br>
<asp:Button id="Button1" onclick="insertyh" runat="server" Text="注册">
</asp:Button>   <input type="reset" value="重置" runat="server">
<br> <br>
<asp:Label id="Label3" runat="server" font-size="Smaller" forecolor="Red"> </asp:Label>
</center>
</form>
<script runat="server">
sub insertyh(sender as object,e as eventargs)
dim sqlconn as new sqlconnection()
dim sqlcmd as new sqlcommand()
dim connstr as string
connstr="server=(local);database=注册系统;uid=www;pwd=123456;"
sqlconn.connectionstring=connstr
sqlconn.open()
sqlcmd.connection=sqlconn
sqlcmd.commandtype=commandtype.text
sqlcmd.commandtext="select * from 用户信息"
sqlcmd.parameters.add("@用户名",sqldbtype.varchar,50,"用户名")
sqlcmd.parameters("@用户名").value=yhm.text
if sqlcmd.executenonquery()=1 then
response.write("已有此用户名!")
exit sub
end if
sqlcmd.parameters.clear()
sqlcmd.commandtext="insert into 用户信息(用户名,密码,邮箱,性别,爱好,来自) values(@用户名,@密码,@邮箱,@性别,@爱好,@来自)"
sqlcmd.parameters.add("@用户名",sqldbtype.varchar,50,"用户名")
sqlcmd.parameters.add("@密码",sqldbtype.int)
sqlcmd.parameters.add("@邮箱",sqldbtype.varchar,100,"邮箱")
sqlcmd.parameters.add("@性别",sqldbtype.varchar,10,"性别")
sqlcmd.parameters.add("@来自",sqldbtype.varchar,50,"来自")
sqlcmd.parameters("@用户名").value=yhm.text
sqlcmd.parameters("@密码").value=cint(mim.text)
sqlcmd.parameters("@邮箱").value=yx.text
if xb.checked then
sqlcmd.parameters("@性别").value=true
else
sqlcmd.parameters("@性别").value=false
end if
sqlcmd.parameters("@来自").value=lz.selecteditem.text

if sqlcmd.executenonquery()=1 then
response.write("注册成功！")
end if
sqlconn.close()
end sub
</script>
</body>
</html>

问题点数：20 回复次数：5 修改删除举报引用回复