提示的错误如下:
用户 'PC-201002012122\IUSR_PC-201002012122' 登录失败。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 用户 'PC-201002012122\IUSR_PC-201002012122' 登录失败。源错误:
行 56: {
行 57: SqlConnection con = db.con();
行 58: con.Open();
行 59: SqlDataAdapter sda = new SqlDataAdapter(que,con);
行 60: DataSet ds = new DataSet();
源文件: c:\Inetpub\wwwroot\dzsw\App_Code\db.cs 行: 58 堆栈跟踪:
[SqlException (0x80131904): 用户 'PC-201002012122\IUSR_PC-201002012122' 登录失败。]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735043
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
db.ds(String que) in c:\Inetpub\wwwroot\dzsw\App_Code\db.cs:58
_Default.BindProductData() in c:\Inetpub\wwwroot\dzsw\Default.aspx.cs:86
_Default.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\dzsw\Default.aspx.cs:37
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
该网站的web.config文件里的设置如下:
<configuration>
<connectionStrings>
<add name="DZSWConnectionString" connectionString="server=(local);Initial Catalog=DZSW;Integrated Security=SSPI"
providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<add key="dbconn" value="server=(local);Initial Catalog=DZSW;Integrated Security=SSPI"/>
</appSettings>
<system.web>
<identity impersonate="true" />
<pages buffer="true" enableViewState="false" enableSessionState="true"></pages>
<!--
设置 compilation debug="true" 将调试符号插入
已编译的页面中。但由于这会
影响性能,因此只在开发过程中将此值
设置为 true。
-->
<compilation debug="true"/>
<!--
通过 <authentication> 节可以配置 ASP.NET 使用的
安全身份验证模式,
以标识传入的用户。
-->
<authentication mode="Windows"/>
<!--
如果在执行请求的过程中出现未处理的错误,
则通过 <customErrors> 节可以配置相应的处理步骤。具体说来,
开发人员通过该节可以配置
要显示的 html 错误页
以代替错误堆栈跟踪。 <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
<globalization fileEncoding="gb2312" requestEncoding="gb2312" responseEncoding="gb2312" culture="zh-CN"/>
</system.web>
</configuration>
公共的db类内容如下:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Text;
using System.Collections;
using System.IO;/// <summary>
/// db 的摘要说明
/// </summary>
public class db
{
public db()
{
// TODO: 在此处添加构造函数逻辑
}
public static SqlConnection con()
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["dbconn"]);
return con;
}
public static bool insert(string que)
{
SqlConnection con = db.con();
con.Open();
SqlCommand cmd = new SqlCommand(que, con);
try
{
int count = Convert.ToInt32(cmd.ExecuteNonQuery());
if (count > 0)
{ return true; }
else
{ return false; }
}
catch (SqlException se)
{
return false;
}
finally
{
con.Close();
} }
public static DataTable ds(string que)
{
SqlConnection con = db.con();
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(que,con);
DataSet ds = new DataSet();
sda.Fill(ds,"product");
return ds.Tables["product"];
con.Close();
}
public static string scr(string que)
{
SqlConnection con = db.con();
con.Open();
SqlCommand cmd = new SqlCommand(que, con);
try
{
return cmd.ExecuteScalar().ToString();
}
catch
{
return null;
}
con.Close();
}
public static DataView dv(string que)
{
SqlConnection con = db.con();
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(que, con);
DataSet ds = new DataSet();
sda.Fill(ds, "product");
DataView dv = new DataView(ds.Tables["product"]);
return dv;
con.Close();
} public static bool deletedata(string que)
{
SqlConnection con = db.con();
con.Open();
SqlCommand cmd = new SqlCommand(que, con);
try
{
cmd.ExecuteNonQuery();
return true;
}
catch (SqlException se)
{
return false;
}
finally
{
con.Close();
}
} public static bool updatedata(string que)
{
SqlConnection con = db.con();
con.Open();
SqlCommand cmd = new SqlCommand(que, con);
try
{
cmd.ExecuteNonQuery();
return true;
}
catch (SqlException se)
{
return false;
}
finally
{
con.Close();
}
}
}
到底是哪里出错了,请高手抽空帮忙看看,感激不尽,麻烦了
用户 'PC-201002012122\IUSR_PC-201002012122' 登录失败。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 用户 'PC-201002012122\IUSR_PC-201002012122' 登录失败。源错误:
行 56: {
行 57: SqlConnection con = db.con();
行 58: con.Open();
行 59: SqlDataAdapter sda = new SqlDataAdapter(que,con);
行 60: DataSet ds = new DataSet();
源文件: c:\Inetpub\wwwroot\dzsw\App_Code\db.cs 行: 58 堆栈跟踪:
[SqlException (0x80131904): 用户 'PC-201002012122\IUSR_PC-201002012122' 登录失败。]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735043
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
db.ds(String que) in c:\Inetpub\wwwroot\dzsw\App_Code\db.cs:58
_Default.BindProductData() in c:\Inetpub\wwwroot\dzsw\Default.aspx.cs:86
_Default.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\dzsw\Default.aspx.cs:37
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
该网站的web.config文件里的设置如下:
<configuration>
<connectionStrings>
<add name="DZSWConnectionString" connectionString="server=(local);Initial Catalog=DZSW;Integrated Security=SSPI"
providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<add key="dbconn" value="server=(local);Initial Catalog=DZSW;Integrated Security=SSPI"/>
</appSettings>
<system.web>
<identity impersonate="true" />
<pages buffer="true" enableViewState="false" enableSessionState="true"></pages>
<!--
设置 compilation debug="true" 将调试符号插入
已编译的页面中。但由于这会
影响性能,因此只在开发过程中将此值
设置为 true。
-->
<compilation debug="true"/>
<!--
通过 <authentication> 节可以配置 ASP.NET 使用的
安全身份验证模式,
以标识传入的用户。
-->
<authentication mode="Windows"/>
<!--
如果在执行请求的过程中出现未处理的错误,
则通过 <customErrors> 节可以配置相应的处理步骤。具体说来,
开发人员通过该节可以配置
要显示的 html 错误页
以代替错误堆栈跟踪。 <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
<globalization fileEncoding="gb2312" requestEncoding="gb2312" responseEncoding="gb2312" culture="zh-CN"/>
</system.web>
</configuration>
公共的db类内容如下:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Text;
using System.Collections;
using System.IO;/// <summary>
/// db 的摘要说明
/// </summary>
public class db
{
public db()
{
// TODO: 在此处添加构造函数逻辑
}
public static SqlConnection con()
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["dbconn"]);
return con;
}
public static bool insert(string que)
{
SqlConnection con = db.con();
con.Open();
SqlCommand cmd = new SqlCommand(que, con);
try
{
int count = Convert.ToInt32(cmd.ExecuteNonQuery());
if (count > 0)
{ return true; }
else
{ return false; }
}
catch (SqlException se)
{
return false;
}
finally
{
con.Close();
} }
public static DataTable ds(string que)
{
SqlConnection con = db.con();
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(que,con);
DataSet ds = new DataSet();
sda.Fill(ds,"product");
return ds.Tables["product"];
con.Close();
}
public static string scr(string que)
{
SqlConnection con = db.con();
con.Open();
SqlCommand cmd = new SqlCommand(que, con);
try
{
return cmd.ExecuteScalar().ToString();
}
catch
{
return null;
}
con.Close();
}
public static DataView dv(string que)
{
SqlConnection con = db.con();
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(que, con);
DataSet ds = new DataSet();
sda.Fill(ds, "product");
DataView dv = new DataView(ds.Tables["product"]);
return dv;
con.Close();
} public static bool deletedata(string que)
{
SqlConnection con = db.con();
con.Open();
SqlCommand cmd = new SqlCommand(que, con);
try
{
cmd.ExecuteNonQuery();
return true;
}
catch (SqlException se)
{
return false;
}
finally
{
con.Close();
}
} public static bool updatedata(string que)
{
SqlConnection con = db.con();
con.Open();
SqlCommand cmd = new SqlCommand(que, con);
try
{
cmd.ExecuteNonQuery();
return true;
}
catch (SqlException se)
{
return false;
}
finally
{
con.Close();
}
}
}
到底是哪里出错了,请高手抽空帮忙看看,感激不尽,麻烦了
更正
你数据库如果是test
用户名sa 密码空 就对应填上
web.config
里面修改一下!
项“integrated security”的值无效。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.ArgumentException: 项“integrated security”的值无效。源错误:
行 26: public static SqlConnection con()
行 27: {
行 28: SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["dbconn"]);
行 29: return con;
行 30: }
用户 'm' 登录失败。该用户与可信 SQL Server 连接无关联。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 用户 'm' 登录失败。该用户与可信 SQL Server 连接无关联。源错误:
行 56: {
行 57: SqlConnection con = db.con();
行 58: con.Open();
行 59: SqlDataAdapter sda = new SqlDataAdapter(que,con);
行 60: DataSet ds = new DataSet();
源文件: c:\Inetpub\wwwroot\dzsw\App_Code\db.cs 行: 58 堆栈跟踪:
[SqlException (0x80131904): 用户 'm' 登录失败。该用户与可信 SQL Server 连接无关联。]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735043
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
db.ds(String que) in c:\Inetpub\wwwroot\dzsw\App_Code\db.cs:58
_Default.BindProductData() in c:\Inetpub\wwwroot\dzsw\Default.aspx.cs:86
_Default.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\dzsw\Default.aspx.cs:37
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
是不是数据库连接代码有错啊?