How to use Substring with Eval function in ASP.Net C#

Hi sagar@saga,

Write your query like below. You need to give alias to the substring column.

select substring(rg.Manufacturer_State,3,40) 'Manufacturer_State' 
from Manufacturer rg, Manu_angle ap 
where rg.Manufact_Email = ap.Manufact_Email AND rg.Manufac = ap.Manufac;

And then use it in the code like below.

<tr><td class="overs" ><%#Eval("Manufacturer_State") %></td></tr>

Check this example with GridView

HTML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="Id" HeaderText="Id" ItemStyle-Width="30" />
        <asp:BoundField DataField="Name" HeaderText="Name" ItemStyle-Width="150" />
        <asp:TemplateField HeaderText="Description" ItemStyle-Width="150">
            <ItemTemplate>
                <%# 
                Eval("Description").ToString().Length > 20 ?
                Eval("Description").ToString().Substring(0, 20) + "..."
                : Eval("Description")
                %>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Namespaces

using System.Data;

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),
                    new DataColumn("Name", typeof(string)),
                    new DataColumn("Description",typeof(string)) });
        dt.Rows.Add(1, "John Hammond", "Works as a scientist in USA.");
        dt.Rows.Add(2, "Mudassar Khan", "ASP.Net programmer and consultant in India.");
        dt.Rows.Add(3, "Suzanne Mathews", "Content Writer in France.");
        dt.Rows.Add(4, "Robert Schidner", "Wild life photographer in Russia.");
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}

Screenshot

i improve my code and its works for me as

select substring(rg.Manufacturer_State,3,40) as state from 
Manufacturer rg, Manu_angle ap where rg.Manufact_Email=ap.Manufact_Email AND rg.Manufac=ap.Manufac;

<tr><td class="overs" ><%#Eval("state") %></td></tr>

Thanks fo all your support