<%@ 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>&nbsp;
        <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参数有问题,各位帮忙啊
我想用个参数来表示一个字段(列)
应该怎么办??