System.Data.SqlClient.SqlException: 用户 'JACK\ASPNET' 登录失败。
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<HTML>
<HEAD>
<link rel="stylesheet" href="intro.css">
<script language="C#" runat="server">
void SubmitBtn_Click(Object sender, EventArgs e) {
if (Page.IsValid) {
//SqlConnection myConnection = new SqlConnection("server=jack;database=pubs;user id=aspnet");
SqlConnection myConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Trusted_Connection=yes");
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Titles where type='" + Category.SelectedItem.Value + "'", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "Titles");
MyList.DataSource = ds.Tables["Titles"].DefaultView;
MyList.DataBind();
}
}
</script>
</HEAD>
<body bgColor="#ffffcc">
<center>
<form action="intro12.aspx" method="post" runat="server" ID="Form1">
<asp:adrotator AdvertisementFile="ads.xml" BorderColor="black" BorderWidth="1" runat="server" ID="Adrotator1" NAME="Adrotator1" />
<table>
<tr>
<td>
姓名:</td>
<td>
<asp:textbox id="Name" runat="server" />
</td>
<td>
<asp:RequiredFieldValidator ControlToValidate="Name" Display="Dynamic" errormessage="必须输入您的姓名!" runat="server" ID="Requiredfieldvalidator1" NAME="Requiredfieldvalidator1" />
</td>
</tr>
<tr>
<td>
类别:</td>
<td>
<asp:dropdownlist id="Category" width="147" runat="server">
<asp:listitem> <!--选择类别--></asp:listitem>
<asp:listitem>psychology</asp:listitem>
<asp:listitem>business</asp:listitem>
<asp:listitem>popular_comp</asp:listitem>
</asp:dropdownlist>
</td>
<td>
<asp:RequiredFieldValidator ControlToValidate="Category" Display="Dynamic" InitialValue="<!--选择类别-->" errormessage="必须选择一个类别!" runat="server" ID="Requiredfieldvalidator2" NAME="Requiredfieldvalidator2" />
</td>
</tr>
<tr>
<td></td>
<td><asp:button text="查找" OnClick="SubmitBtn_Click" runat="server" ID="Button1" NAME="Button1" /></td>
</tr>
</table>
<p>
<asp:datalist id="MyList" repeatcolumns="2" borderwidth="0" runat="server">
<ItemTemplate>
<table>
<tr>
<td>
<img src='<%# DataBinder.Eval(Container.DataItem, "title_id", "/quickstart/aspplus/images/title-{0}.gif") %>'>
</td>
<td width="250" valign="top">
<b>
<%# DataBinder.Eval(Container.DataItem, "title") %>
</b>
<br>
<br>
价格:<%# DataBinder.Eval(Container.DataItem, "price", "${0}") %>
</td>
</tr>
</table>
</ItemTemplate>
</asp:datalist>
</form>
</center>
</P>
</body>
</HTML>
以上代码再点击按钮运行时会出现如标题所示的错误
将连接命令改为注释的代码行,刚运行正常
注:C:\WINNT\Microsoft.NET\Framework\v1.0.3705\CONFIG\machine.config文件中的userName="machine"或"SYSTEM",以上代码还是出现同样的错误
求教!!!