Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

how to show limited characters in gridview columns using asp.net and how to show the tooltip for gridview rows and cells or how to show limit characters in gridview column using asp.net

Dec 10, 2010
Introduction:

In this article I will explain how to show limited characters in gridview using asp.net.

Description:

I have created one application for that we have prepared one feedback form to collect feedback from users regarding our application for that we have taken gridview to bind all the feedbacks into one page. Here some of the users have given one line of feedback some of the users have given two lines of feedback remaining people have given feedback with bigger matter at that time if we bind all the feedbacks to one gridview at that time gridview size has increased a lot and in some rows matter is small but columns size is bigger that is just like this
For that reason we tried to maintain consistency for entire gridview to maintain consistency for gridview we need to write functionality in Gridview RowDataBound event
Design your aspx page like this


<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Gridview With Limited Characters</title>
</head>
<body>
<form id="form1" runat="server">
<table   cellpadding="0" cellspacing="0" width="300px" align="center">
<tr>
<td>
<asp:GridView ID="GridView1" runat="server" Width="100%" 
CssClass="feedbacklink" AutoGenerateSelectButton="True"  
onrowdatabound="GridView1_RowDataBound" PageSize="5" >
</asp:GridView>
</td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td>
<asp:TextBox ID="txtmsg" runat="server" TextMode="MultiLine"
CssClass="textarea" Width="300px" ></asp:TextBox></td>
</tr>
</table>
</form>
</body>
</html>


In code behind write this functionality to bind gridview and write functionality in Gridview_Rowdatabound to limit the characters in gridview columns.


string strConn = "Data Source=MYSystem;Initial Catalog=MySamplesDB;Integrated Security=True";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
bindGrid();

}
public void bindGrid()
{
SqlConnection con = new SqlConnection(strConn);
DataSet myDataSet = new DataSet();
SqlCommand cmd = new SqlCommand("Select * from Feedback", con);
// cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter myDataAdapter = new SqlDataAdapter(cmd);
myDataAdapter.Fill(myDataSet);
GridView1.DataSource = myDataSet;
GridView1.DataBind();
// GridView1.Columns[3].Visible = false;
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
int i = 0;
e.Row.Cells[3].Visible = false;
if (e.Row.RowType == DataControlRowType.DataRow)
{
foreach (TableCell cell in e.Row.Cells)
{
i++;
string s = cell.Text;
if (cell.Text.Length > 25 && (i == 3))
cell.Text = cell.Text.Substring(0, 25) + "....";
cell.ToolTip = s;
}
}
}


After writing this functionality gridview looks like this

 

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email

17 comments :

Naresh said...

I'm getting error as
e.Row.Cells[3].Visible = false; ====> Error:Specified argument was out of range of valid vavalues parameter:Index

Anonymous said...

Excelent!!!

Works fine!!!!

Thanks!

Anonymous said...

Work like a charm!!!

Thanks!

Y said...

but when Export to excel required then what to do?
It Export with "......" not whole data

Unknown said...

what is "!IsPostBack"

Anonymous said...

I have followed all your code, and in my database, I added the 3rd column is id, so when my code has changed the cell [2] cell [3] but did not show up "...."as in code which instead show all the data in the column description into one long line. In my database is: id, subject, description.Please help me!!!!

Unknown said...

Nat chaal tu.....................

Unknown said...

Thank's

Anonymous said...

what i have to do if have i designed gridview in my own that means inside 1 row i spllited into many table???? plz help me out

Anonymous said...

i getting this error

e.Row.Cells[3].Visible = false; => Error:Specified argument was out of range of valid vavalues parameter:Index

Christo said...

Hi

This is fine, but the issue is, if i want to export the gridview to Excel, than '.....' is showing instead of full statement. so, please tell the alternate way to export report to excel

Anonymous said...

thank u ..suresh...u r amazing

Sam said...

Thanks This Helped a Lot !!

Anonymous said...

Thanks a lott.

Unknown said...

nice ...you are too good..

Sakshi said...

Thanks for sharing with us...

Inzynier Umair said...

How to use this substring method for ajaxhtmlextender content. i.e the data which is stored in database having html tags so while using subtring method it shows the data with html tags so can you please tell me the alternative solution of substring for ajaxhtmExtender content. and im not displaying it in gridview im simply using div tag with run=server in asp.net c#

Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.