有关模糊查询？

SqlConnection Cn=new SqlConnection("server=(local);uid=sa;pwd=;database=northwind");
Cn.Open();
SqlCommand Cmd=new SqlCommand("SELECT CategoryID, CategoryName "
+"FROM Categories "
+"WHERE (CategoryName LIKE '%"
+TextBox1.Text +"%')",Cn);
SqlDataReader Dr=Cmd.ExecuteReader();
while(Dr.Read())
{
MessageBox.Show(Dr[1].ToString());
}
//在文本框TextBox1中输入你要做模糊查询的字符串.