Solved

Trim text in gridview column

Posted on 2008-10-02
2
1,871 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

789 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