Cannot Find Column error

[Steve Bishop]

I can't figure out why I'm getting this error when trying to use a row
filter. My query string is coming over ok, but I can't seem to work it
into my SQL if I use Request.QueryString or capture it in my objCN
variable . Help appreciated.:

Error: Cannot find column [ATOZ].

Line of error: dvCN.RowFilter = "CustomerNumber = " +
Request.QueryString["CustomerNumber"];

All the code:

private void Page_Load(object sender, System.EventArgs e){

object objCN = Request.QueryString["CustomerNumber"];

//test objext
Response.Write(objCN);

OdbcConnection myConn2 = new OdbcConnection("dsn=SOTAMAS90AUTO");
String strSQL = "SELECT Division + CustomerNumber As
KeyField, Division, CustomerNumber, CustomerName, ContactCode, City,
State, ZipCode, PhoneNumber FROM AR1_CustomerMaster";

//DataAdapter Setup
OdbcDataAdapter adapter = new OdbcDataAdapter(strSQL,
myConn2);

//DataSet, DataAdapter & Table
DataSet objDataSet = new DataSet();
adapter.Fill(objDataSet, "dt2AR1");
DataTable dt2AR1 = objDataSet.Tables["dt2AR1"];


//Set up filter...
DataView dvCN = new DataView(dt2AR1);
dvCN.RowFilter = "CustomerNumber = " +
Request.QueryString["CustomerNumber"];


dgAR1.DataSource = dvCN;
dgAR1.DataBind();
}

 

[Steve Bishop]

Still having problems. Changed my code a bit, but now getting error
"Syntax error: Missing operand after 'ABF' operator" that point to the
row filter line. Help appreciated. Latest code:
private void Page_Load(object sender, System.EventArgs e){

object objCN = Request.QueryString["CustomerNumber"];

//test object
Response.Write(objCN);

OdbcConnection myConn2 = new OdbcConnection("dsn=SOTAMAS90AUTO");
String strSQL = "SELECT Division + CustomerNumber As
KeyField, Division, CustomerNumber, CustomerName, ContactCode, City,
State, ZipCode, PhoneNumber FROM AR1_CustomerMaster";

//DataAdapter Setup
OdbcDataAdapter adapter = new OdbcDataAdapter(strSQL,
myConn2);

//DataSet, DataAdapter & Table
DataSet objDataSet = new DataSet();
adapter.Fill(objDataSet, "dt2AR1");
DataTable dt2AR1 = objDataSet.Tables["dt2AR1"];


//Set up filter...

string Filter = "CustomerNumber "+ objCN;
objDataSet.Tables[0].DefaultView.RowFilter = Filter;
objDataSet.Tables["dt2AR1"].DefaultView.RowFilter = Filter;


dgAR1.DataSource = objDataSet.Tables["dt2AR1"];
dgAR1.DataBind();
}

 

[Steve Bishop]

Woops! forget the = after CustomerNumber in the Filter, but I'm still
getting "Column not found" error. Help appreciated.

Steve

 

[Steve Bishop]

Found the problem - it was just syntax with the filter:
string Filter = "CustomerNumber = '" + objCN + "'"

Thanks,
Steve