在DataTable中添加筛选条件

     DataTable dt = new DataTable();//创建一个DataTable的实例； 

//写一个简单的SqlHelper

  public static class SqlHelper
    {
       static string strCon = System.Configuration.ConfigurationManager.ConnectionStrings["strConn"].ConnectionString;
        /// <summary>
        /// 执行增加、修改、删除操作；
        /// </summary>
        /// <param name="commandText">执行操作的SQL语句</param>
        /// <param name="prmarters">参与运算的参数</param>
        /// <returns>操作成功则返回受影响的行数</returns>
        public static int ExecuteNonQuery(string commandText, params SqlParameter[] parameters)
        {
            int result = -1;
          
                using (SqlConnection con = new SqlConnection(strCon))
                {
                    using (SqlCommand cmd = new SqlCommand(commandText, con))
                    {
                        if (parameters != null)
                        {
                            cmd.Parameters.AddRange(parameters);
                        }
                        con.Open();
                        result = cmd.ExecuteNonQuery();
                    }
              }
           
            return result;
        }
        /// <summary>
        /// 以表的形式查询数据
        /// </summary>
        /// <param name="commandText">执行操作的SQL语句</param>
        /// <param name="parameters">参与运算的参数</param>
        /// <returns>操作成功则返回数据表在本地内存中</returns>
        public static DataTable ExecuteDataTable(string commandText, params SqlParameter[] parameters)
        {
             DataSet ds = new DataSet();
            using (SqlConnection con=new SqlConnection (strCon))
            {
                SqlDataAdapter da=null;
                if (parameters!=null)
                {
                    da.SelectCommand.Parameters.AddRange(parameters);
                }
                da = new SqlDataAdapter(commandText, con);
                da.Fill(ds);
              
            }
            return ds.Tables[0];
        }
    }

private void Init()//将数据绑架带datagridview上
        {
            string sql="select pId as'序号', (select  ptName from dbo.PhoneType where ptId=pTypeId) as'分组', pName as'姓名', pCellPhone as'手机', pHomePhone as'座机' from dbo.PhoneNum";
            dt=SqlHelper.ExecuteDataTable(sql, null);
            dataGridViewPhoneInfo.DataSource = dt;
        }

private void Seach()//根据不同筛选条件 改变datagirdview显示的数据，
        {//该语句就相当与Sql语句中的where 条件
           dt.DefaultView.RowFilter = "姓名 like '%" + this.txtSeachName.Text.Trim() + "%' and 分组 like '%" + this.cmbSeachGroup.Text.Trim() + "%' and 手机 like '%" + this.txtSeachNo.Text.Trim() + "%' and 座机 like '%" + this.txtSeachHomeNO.Text.Trim() + "%'";
        }

转载于:https://www.cnblogs.com/_best/archive/2011/08/25/2153784.html