Sunday, February 22, 2015

How to show limited characters in gridview column using asp.net

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

 


 Now over to you:
"A blog is nothing without reader's feedback and comments. So please provide your valuable feedback so that i can make this blog better and If you like my work, you can appreciate by leaving your comments. Stay tuned and stay connected for more technical updates."


No comments:

Post a Comment