>That was the first thing I tried.
>
>Didn't work.

I tried to reproduce the problem but it works for me. intField = 1 and intFied = '1' both works for me. Here is a sample code:

  this.sqlConnection2.Open();
  this.sqlDataAdapter1.Fill(this.dataSet11,"tblLookup");
  this.dataSet11.Tables["tblLookup"].DefaultView.RowFilter = "ID = 1";
  this.DataGrid1.DataSource = this.dataSet11.Tables["tblLookup"].DefaultView;
  this.DataBind();