How to Display TOOL TIP in Gridview Column on mouse over

Question

0.00/5 (No votes)

See more:

How to Display TOOL TIP in Gridview Column.
====================================

am working on asp.net c# sqlServer2005.

i have large amount of data in database i have displayed in gridview its fine.

i have one column in Gridview with name Days. In this column i have M T W Th F S Su 0.

so when the user keeps the mouse pointer on M it should Monday and
T - Tuesday
W- Wednesday
Th-Thursday
F - Friday
S- Saturday
Su - Sunday
0 - Not Available.

Please can u help me how to set tooltip for this column.

In one column i should display 8 tool tips.

Please help Thanks.

Posted 11-Jan-13 22:51pm

Ranjith Reddy CSE

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tharaka MTR · Answer 1 · 2013-01-11T23:16:00

Solution 1

Try this

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            var MONTH_COLUMN_SELL = 8; // Please change your month column cell here
            e.Row.Cells[MONTH_COLUMN_SELL].ToolTip = getMonthName(e.Row.Cells[MONTH_COLUMN_SELL].Text);
        }
    }

    private string getMonthName(string monthCode)
    {
        string monthName = string.Empty;
        switch (monthCode)
        {
            case "M":
                monthName="Monday";
                break;

            // add other condition as you like
        }
        return monthName;
    }

Here is another method to do this, you have to modify your grid view binding way using Template field

ASP.NET

<asp:TemplateField HeaderText="ClearanceNumber">
 <ItemTemplate>
      <asp:Label ID="lblClearanceNumber" runat="server"
                Text='<%# Eval("ClearanceNumber") %>' 
                Tooltip='<%# Eval("ClearanceNumber") %>'>
      </asp:Label>      
 </ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Days">
 <ItemTemplate>
      <asp:Label ID="lblDays" runat="server"
                Text='<%# Eval("Days") %>' 
                Tooltip='<%# getMonthName(Eval("Days")) %>'>
      </asp:Label>      
 </ItemTemplate>
</asp:TemplateField>

In code behind

C#

protected string getMonthName(string monthCode)
    {
        string monthName = string.Empty;
        switch (monthCode)
        {
            case "M":
                monthName = "Monday";
                break;

            case "T":
                monthName = "Tuesday";
                break;

            case "W":
                monthName = "Wednesday";
                break;

            case "Th":
                monthName = "Thursday";
                break;

            case "F":
                monthName = "Friday";
                break;

            case "S":
                monthName = "Saturday";
                break;

            case "Su":
                monthName = "Sunday";
                break;

            // add other condition as you like
        }
        return monthName;
    }

please check this method scope is protected

Posted 11-Jan-13 23:16pm

Tharaka MTR

Updated 12-Jan-13 0:32am

v4

Comments

Ranjith Reddy CSE 12-Jan-13 5:23am

my cell is 8....please help

Tharaka MTR 12-Jan-13 5:28am

ok. I have modified the code, you have to modify the switch statement with other condition such as "T" - Tuesday, "W" - Wednesday etc..

Please try and let me know if you need any more help

Ranjith Reddy CSE 12-Jan-13 5:35am

Sorry Boss, its not working....when i keep mouse pointer...its unable to show. PLEASE HELP.

Tharaka MTR 12-Jan-13 5:38am

could you please show me your code behind file and grid view layout..
did you debug the project and check whether the event is firing or not?

Ranjith Reddy CSE 12-Jan-13 5:49am

This is my code.

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Web.Configuration;

public partial class _Default : System.Web.UI.Page
{
private static readonly string _connString = String.Empty;
SqlConnection con = new SqlConnection(_connString);

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadGridData();
}

}

private void LoadGridData()
{
SqlConnection con = new SqlConnection(_connString);

SqlCommand cmd = new SqlCommand("Select * from Flight", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);

GridView1.DataSource = ds;
GridView1.DataBind();
}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
var MONTH_COLUMN_SELL = 8; // Please change your month column cell here
e.Row.Cells[MONTH_COLUMN_SELL].ToolTip = getMonthName(e.Row.Cells[MONTH_COLUMN_SELL].Text);
}
}

private string getMonthName(string monthCode)
{
string monthName = string.Empty;
switch (monthCode)
{
case "M":
monthName = "Monday";
break;

case "T":
monthName = "Tuesday";
break;

case "W":
monthName = "Wednesday";
break;

case "Th":
monthName = "Thursday";
break;

case "F":
monthName = "Friday";
break;

case "S":
monthName = "Saturday";
break;

case "Su":
monthName = "Sunday";
break;

// add other condition as you like
}
return monthName;
}

static _Default()
{
_connString = WebConfigurationManager.ConnectionStrings["CFS_DBConnectionString"].ConnectionString;
}
}

Tharaka MTR 12-Jan-13 6:01am

well. Could you please add two debug point to "GridView1_RowDataBound" and "getMonthName" functions and check whether event is firing or not?

Tharaka MTR 12-Jan-13 6:02am

And could you please send me your grid view layout html also?

Ranjith Reddy CSE 12-Jan-13 6:07am

Gridview Html Layout
====================

<asp:GridView ID="GridView1" runat="server" HorizontalAlign="Center"
Width="1300px" AutoGenerateColumns="False" BackColor="White"
BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3"
GridLines="Horizontal" onrowdatabound="GridView1_RowDataBound">
<rowstyle backcolor="#E7E7FF" forecolor="#4A3C8C" horizontalalign="Center">
<footerstyle backcolor="#B5C7DE" forecolor="#4A3C8C">
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<alternatingrowstyle backcolor="#F7F7F7">

Ranjith Reddy CSE 12-Jan-13 6:09am

please help me....THANKS

Tharaka MTR 12-Jan-13 6:11am

did you add the debug points as I said and check? are you sure your column is 8? column starting index is 0, not 1. please debug the project and give me your results

Ranjith Reddy CSE 12-Jan-13 6:12am

When i build the solution - > it shows Succeed...Then whats the problem for tooltip.

Ranjith Reddy CSE 12-Jan-13 6:15am

ya i have added the break points as u have said. ya starting index is 0 but my column is 8.

Ranjith Reddy CSE 12-Jan-13 6:18am

these are my columns
1)ClearanceNumber
2)CodeFlightId
3)DateLastChange
4) DateValidFrom
5)DateValidTo
6)Reservation No
7)AircraftType
8)CityCode
9)Days

see if index is 0 then our Days column will be 8

Please help me...Thanks

Ranjith Reddy CSE 12-Jan-13 6:30am

anybody there, Please help.

Tharaka MTR 12-Jan-13 6:31am

Ok, I have added another solution, if you can modify your grid view binding template, then please try that also

Ranjith Reddy CSE 12-Jan-13 6:53am

No, this is also not working..........Please help me Codeproject team.

Ranjith Reddy CSE 12-Jan-13 6:59am

This is the error am getting after using template fields..

The best overloaded method match for 'DefaultPage.getMonthName(string)' has some invalid arguments

Please solve.

Ranjith Reddy CSE 13-Jan-13 3:58am

hello, please solve my problem display tooltip onmouse over in gridview

ridoy · Answer 2 · 2013-01-11T23:18:00

These for you..
http://vinaysingh2507.blogspot.com/2012/07/how-to-show-gridview-as-tooltip-on.html[^]
http://forums.asp.net/p/1819794/5047458.aspx/1?How+to+show+Gridview+as+a+tooltip+on+mouseover+of+a+cell+of+gridview+in+asp+net+C+[^]
How to show tooltip text in gridview row on mouseover?[^]

Mayank Topiwala · Answer 3 · 2013-01-11T23:18:00

Solution 3

Hi Ranjith

Choose EditColumns property of DataGridView. First Click on particular column and then go to ToolTipText property on right side pane and finally edit your Text.

Posted 11-Jan-13 23:18pm

Mayank Topiwala