求解啊小弟我该如何样才能按照下面的条件吧数据重数据库里查出来

求解啊，我该怎么样才能按照上面的条件吧数据重数据库里查出来啊
private void btncx_Click(object sender, EventArgs e)
  {
  if (cmdlx.Text == "全部" )
  {
  DataView view = set.Tables[0].DefaultView;
  view.RowFilter = "txtname like '%" + txtname.Text + "%'";
  DG.DataSource = view;
  }
  else if (cmdlx.Text == "智能机")
  {

  }
  else if(cmdlx.Text == "普通机")
  {

  }
  else if(cmdlx.Text == "其他")
  {
   
  }

[解决办法]
直接用sql语句查写出来就好了
[解决办法]

C# code

private void btncx_Click(object sender, EventArgs e)  {  DataView view = set.Tables[0].DefaultView;  if (cmdlx.Text!= "全部" )  {  view.RowFilter = "txtname like '%" + txtname.Text + "%'";  }  DG.DataSource = view;