Solved

Trim text in gridview column

Posted on 2008-10-02
2
1,866 Views
Last Modified: 2013-12-17
Is it possible to do a trim the text in a gridview to only show the first 10 characters.
I can do this in sql, but i really need to be able to trim the text once in the gridview.

0
Comment
Question by:Mr_Shaw
2 Comments
 
LVL 2

Accepted Solution

by:
jvulliet earned 500 total points
ID: 22625132
Hello,

for this purpose you can create a Template field with a Label in it, then use the RowDataBound event in the code behind to set the Text property ( I used a datarowview as dataitem, which is if you Bind your GridView with a DataSet).

See the code snippet.

Thanks
ASP.NET Code:   
 
<asp:gridview ID="gridview" runat="server" AutoGenerateColumns="False" OnRowDataBound="gridview_RowDataBound">
    <Columns>
        <asp:TemplateField  HeaderText="Field">
            <ItemTemplate>
                <asp:Label ID="lblfield" runat="server" ></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
 </asp:gridview>
 
Code Behind:
 
    protected void gridview_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            DataRowView drv = (DataRowView)e.Row.DataItem;
            Label lblfield = (Label)e.Row.FindControl("lblfield");
            lblfield.Text = drv["MyField"].ToString().Substring(0, 10);
        }
    }

Open in new window

0
 

Author Closing Comment

by:Mr_Shaw
ID: 31502410
Thanks
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question