Tuesday, March 27, 2012

Aliased column in stored procedure not seen by datagrid

i have an aliased column in an sql statement that works fine when
displaying its output in a datagrid, but when I transfer the sql
statement into a stored procedure , the datagrid can't see it. I get an
error "{"DataBinder.Eval: 'System.Data.DataRowView' does not contain a
property with the name myaliasedcolumn." }Hi

You may want to post the DDL for this. If you are using exactly the same SQL
Statement then it should be the same. You may want make sure that you SET
NOCOUNT ON at the start of the procedure.

John

".Net Sports" <ballz2wall@.cox.net> wrote in message
news:1126914453.889098.79790@.g47g2000cwa.googlegro ups.com...
>i have an aliased column in an sql statement that works fine when
> displaying its output in a datagrid, but when I transfer the sql
> statement into a stored procedure , the datagrid can't see it. I get an
> error "{"DataBinder.Eval: 'System.Data.DataRowView' does not contain a
> property with the name myaliasedcolumn." }

No comments:

Post a Comment