<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="choose" runat="server" AutoPostBack="True">
<asp:ListItem Value="SchoolName">学校名</asp:ListItem>
<asp:ListItem Value="CourseName">课程名</asp:ListItem>
<asp:ListItem Value="TeacherName">教师名</asp:ListItem>
<asp:ListItem Value="MajorSubject">学科类</asp:ListItem>
</asp:DropDownList>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" />
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None">
<PagerSettings FirstPageText="首页" LastPageText="尾页" Mode="NextPreviousFirstLast"
NextPageText="下一页" PreviousPageText="上一页" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" SortExpression="Id" />
<asp:BoundField DataField="SchoolName" HeaderText="SchoolName" SortExpression="SchoolName" />
<asp:BoundField DataField="CourseName" HeaderText="CourseName" SortExpression="CourseName" />
<asp:BoundField DataField="TeacherName" HeaderText="TeacherName" SortExpression="TeacherName" />
<asp:BoundField DataField="CourseLevel" HeaderText="CourseLevel" SortExpression="CourseLevel" />
<asp:BoundField DataField="MajorSubject" HeaderText="MajorSubject" SortExpression="MajorSubject" />
<asp:BoundField DataField="MinorSubject" HeaderText="MinorSubject" SortExpression="MinorSubject" />
<asp:CheckBoxField DataField="IsAvailable" HeaderText="IsAvailable" SortExpression="IsAvailable" />
</Columns>
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CourseInfoConnectionString %>"
SelectCommand="SELECT Id, SchoolName, CourseName, TeacherName, CourseLevel, MajorSubject, MinorSubject, IsAvailable FROM Course WHERE (@Select LIKE '%' + @Text + '%')">
<SelectParameters>
<asp:ControlParameter ControlID="choose" Name="Select" PropertyName="SelectedValue" Type="String" DefaultValue="SchoolName" />
<asp:ControlParameter ControlID="TextBox1" Name="Text" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</form>
</body>
</html>数据库连接正常,没有返回结果
应该是
SelectCommand="SELECT Id, SchoolName, CourseName, TeacherName, CourseLevel, MajorSubject, MinorSubject, IsAvailable FROM Course WHERE (@Select LIKE '%' + @Text + '%')"
是的@Select参数有问题,各位帮忙啊
我想用个参数来表示一个字段(列)
应该怎么办??
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="choose" runat="server" AutoPostBack="True">
<asp:ListItem Value="SchoolName">学校名</asp:ListItem>
<asp:ListItem Value="CourseName">课程名</asp:ListItem>
<asp:ListItem Value="TeacherName">教师名</asp:ListItem>
<asp:ListItem Value="MajorSubject">学科类</asp:ListItem>
</asp:DropDownList>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" />
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None">
<PagerSettings FirstPageText="首页" LastPageText="尾页" Mode="NextPreviousFirstLast"
NextPageText="下一页" PreviousPageText="上一页" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" SortExpression="Id" />
<asp:BoundField DataField="SchoolName" HeaderText="SchoolName" SortExpression="SchoolName" />
<asp:BoundField DataField="CourseName" HeaderText="CourseName" SortExpression="CourseName" />
<asp:BoundField DataField="TeacherName" HeaderText="TeacherName" SortExpression="TeacherName" />
<asp:BoundField DataField="CourseLevel" HeaderText="CourseLevel" SortExpression="CourseLevel" />
<asp:BoundField DataField="MajorSubject" HeaderText="MajorSubject" SortExpression="MajorSubject" />
<asp:BoundField DataField="MinorSubject" HeaderText="MinorSubject" SortExpression="MinorSubject" />
<asp:CheckBoxField DataField="IsAvailable" HeaderText="IsAvailable" SortExpression="IsAvailable" />
</Columns>
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CourseInfoConnectionString %>"
SelectCommand="SELECT Id, SchoolName, CourseName, TeacherName, CourseLevel, MajorSubject, MinorSubject, IsAvailable FROM Course WHERE (@Select LIKE '%' + @Text + '%')">
<SelectParameters>
<asp:ControlParameter ControlID="choose" Name="Select" PropertyName="SelectedValue" Type="String" DefaultValue="SchoolName" />
<asp:ControlParameter ControlID="TextBox1" Name="Text" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</form>
</body>
</html>数据库连接正常,没有返回结果
应该是
SelectCommand="SELECT Id, SchoolName, CourseName, TeacherName, CourseLevel, MajorSubject, MinorSubject, IsAvailable FROM Course WHERE (@Select LIKE '%' + @Text + '%')"
是的@Select参数有问题,各位帮忙啊
我想用个参数来表示一个字段(列)
应该怎么办??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货