当前位置: 代码迷 >> Sql Server >> 在VS2010实现模糊查询(LIKE格式)的有关问题
  详细解决方案

在VS2010实现模糊查询(LIKE格式)的有关问题

热度:96   发布时间:2016-04-25 00:44:42.0
在VS2010实现模糊查询(LIKE格式)的问题
            string temp = txt姓名查找.Text;

            string ConStr = ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(ConStr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText =@"Select *from T_Person where Name LIKE '%:temp%'";
                    using (SqlDataReader read=cmd.ExecuteReader())
                    {
                        while(read.Read())
                        {
                           if (lbx模糊显示.Text == "")
                          {
                            lbx模糊显示.Text = Convert.ToString(read.GetOrdinal("Name")) ;
                          }
                          else
                         {
                            lbx模糊显示.Text = lbx模糊显示.Text + Convert.ToString(read.GetOrdinal("Name")) ; 
                          }
                        }
                         MessageBox.Show(Convert.ToString(read.GetOrdinal("Name")));
                    }                   

                }
                if (lbx模糊显示.Text != "")
  相关解决方案