i have data like '2,delhi' in database in which i want to remove first two char i.e '2,'
i write query for this is
select substring(rg.Manufacturer_State,3,40) from
Manufacturer rg,Manu_angle ap where rg.Manufact_Email=ap.Manufact_Email AND rg.Manufac=ap.Manufac;
which run fine on mssql
but when i call it in listview using c# it gives error:
DataBinding: 'substring(rg' is not a valid indexed expression.
on the line
<tr><td class="overs" ><%#Eval("substring(rg.Manufacturer_State,3,40)") %></td></tr>
and when i use
<tr><td class="overs" ><%#Eval("Manufacturer_State") %></td></tr>
it gives error
DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'Manufacturer_State'.
<tr><td class="overs" ><%#Eval("Manufacturer_State") %></td></tr>