Data fetching by using adapter

Question

Hi:
I am using dot net 2.0 and I am working with sqlserver 2000
data is not fetching.... through datatable
int count;
adpt = new SqlDataAdapter("select * from WorkerCode where WCode='" + this.flex1.get_TextMatrix(this.count, 1) + "'",conn);
  dt = new DataTable();
  adpt.Fill(dt);
  if (this.dt.Rows.Count > 0)
  {
  // this.adodc1.Recordset.Update(2, this.flex1.get_TextMatrix(this.count, 2));
  //this.adodc1.Recordset.Update(3, this.flex1.get_TextMatrix(this.count, 3));
  //dt.Rows.Count.Equals(2,this.flex1.get_TextMatrix(this.count,2));
  //  dt.Rows.Count.Equals(3, this.flex1.get_TextMatrix(this.count, 3));
  }

anybody help me...