<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<Script runat="server">
void submit_Click(Object Src, EventArgs E) { 
    SqlConnection Conn;
    Conn = new SqlConnection("server=127.0.0.1;database=tea_manage;uid=sa;password='123'");;
    String strSQL = "select * from course_inf " ;
    SqlCommand Comm = new SqlCommand(strSQL,Conn);
    SqlDataAdapter da = new SqlDataAdapter();
    da.SelectCommand = Comm;
    Conn.Open();

    DataSet ds = new DataSet();
    da.Fill(ds,"course_inf");
    DataView dv = new DataView(ds.Tables["course_inf"]);
    dv.RowFilter = "专业= '"+zhuanye.Text+"'";
    
    dg.DataSource = dv;
    dg.DataBind();
    Conn.Close();
}

</script>
<form name="myform"  runat="server">
    专业:
      <asp:TextBox ID="zhuanye"  size="15" runat="server"/>
    年级: 
 <asp:DropDownList id="nianji" 
              AutoPostBack="True"
             
              runat="server">
      <asp:ListItem value="04" selected="true">04级</asp:ListItem>
      <asp:ListItem value="03">03</asp:ListItem>
       <asp:ListItem value="05">05</asp:ListItem>
   </asp:DropDownList>
   <asp:Button id="chaxun" Text="按专业/年级查询" OnClick="submit_Click"  runat="server" />
<asp:label id="Message" runat="server"/><br>
<asp:DataGrid id="dg" runat="server"
          Width="500" BackColor="#ccccff" 
          BorderColor="black"
          CellPadding=3 CellSpacing="0"
          Font-Name="Verdana" Font-Size="8pt"
          HeaderStyle-BackColor="#aaaadd"
          
           />
        </form> 
我想把年级的内容也放到查询语句中 要怎么改下啊 ??????????????