using isnull in query is not detecting column names

[vinod allapu]

Hi all ,

I am using sql2000 in my project. I have a sql query like this

"select tblstudents.studentname, isnull( tblpayments.Fee , 0 ) from tblstudents,tblpayments where ..............."

In my .cs file i want to print response

response.write(dt.rows[0]["Fee"].tostring());

but it is showing error :: Column 'Fee' does not belong to table .

here in my datatable i need to put 0 in null values, but it should be done by sql and column name should be detectable in .cs file.
Can anyone do this.

Thanking you all

[r035198x]

Try using

isnull( tblpayments.Fee , 0 ) as Fee

so that you return a column called fee.
Also consider using coalesce instead of isnull. Coalesce is an SQL standard (available in all SQL standars compliant RDBMS) while isnull is only available in MSSQL.

[vinod allapu]

Hi boss,

Thats great I was missing alias .
many thanks for your reply boss.

[r035198x]

Welcome.

P.S You can call me r035198x.