ช่วยดูหน่อยนะครับว่า code ถูกหรือเปล่า จะทำ gridview search

<form id="form1" runat="server">
    <asp:TextBox ID="txtKeyWord" runat="server"></asp:TextBox>
    <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
     <asp:GridView id="myGridView" runat="server"  onRowDataBound="myGridView_RowDataBound">
            <HeaderStyle backcolor="#cccccc"></HeaderStyle>
            <AlternatingRowStyle backcolor="#e8e8e8"></AlternatingRowStyle>
            <Columns>
                <asp:TemplateField HeaderText="รหัสวิชา">
                    <ItemTemplate>
                        <asp:Label id="lblid_subject" runat="server"></asp:Label> 
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="รายวิชา">
                    <ItemTemplate>
                        <asp:Label id="lblname_subject" runat="server"></asp:Label> 
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="รหัสอาจารย์">
                    <ItemTemplate>
                        <asp:Label id="lblid_teacher" runat="server"></asp:Label> 
                    </ItemTemplate>
                </asp:TemplateField>   
            </Columns>
        </asp:GridView>
        </form>
   

String strKeyWord;
    void Page_Load(object sender, EventArgs e)
    {
        strKeyWord = this.txtKeyWord.Text;
    }

    void BindData()
    {
        string connection = ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
        SqlConnection conn = new SqlConnection(connection);
        conn.Open();
        SqlCommand cmd = conn.CreateCommand();
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = "select * from subject where (id_subject like '%" + strKeyWord + "%' id_teacher '%" + strKeyWord + "%') ";

    
        SqlDataAdapter dtAdapter = new SqlDataAdapter();
        DataSet ds = new DataSet();
      
        cmd.Connection = conn;
     
        cmd.CommandType = CommandType.Text;


        dtAdapter.SelectCommand = cmd;

        dtAdapter.Fill(ds);

       
        myGridView.DataSource = ds;
        myGridView.DataBind();

        dtAdapter = null;
        conn.Close();
        conn = null;

    }

    void myGridView_RowDataBound(Object s, GridViewRowEventArgs e)
    {
        //*** subjectID ***//
        Label lblid_subject = (Label)(e.Row.FindControl("lblid_subject"));
        if (lblid_subject != null)
        {
            lblid_subject.Text = (string)DataBinder.Eval(e.Row.DataItem, "id_subject");
        }

        //*** namesubject ***//
        Label lblname_subject = (Label)(e.Row.FindControl("lblname_subject"));
        if (lblname_subject != null)
        {
            lblname_subject.Text = (string)DataBinder.Eval(e.Row.DataItem, "name_subject");
        }

        //*** รหัสอาจารย์ ***//
        Label lblid_teacher = (Label)(e.Row.FindControl("lblid_teacher"));
        if (lblid_teacher != null)
        {
            lblid_teacher.Text = (string)DataBinder.Eval(e.Row.DataItem, "id_teacher");
        }

        
    }

  

    protected void Button1_Click(object sender, EventArgs e)
    {
        BindData();
    }