We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

showing html table data in tooltip[Answered] RSS

4 replies

Last post Jul 01, 2020 01:00 PM by asteranup

‹ Previous Thread|Next Thread ›

Shortcuts

mazharul007

Member

12 Points

42 Posts

showing html table data in tooltip

Jun 28, 2020 04:14 PM|mazharul007|LINK

Hello i have made a dynamic table now i want to show some specific data in to a tooltip but the data is not showing. I am confused how can i show this.

Here is my created method addTableContentWorkHistory

public static Table addTableContentWorkHistory(Table table, DataTable dt)
    {

        StringBuilder workHistory = new StringBuilder(@"<table style=""font-family: Tahoma; font-size: 8pt;"" border=""0"">");
        foreach (DataRow dtRow in dt.Rows)
        {
            workHistory.AppendFormat(@"<tr><td>{0}</td><td>{1:(###) ###-####}</td></tr>", dtRow.Field<string>("PositionName"),dtRow.Field<string>("InstituteName"));
        }
        workHistory.Append("</table>");
        TableRow tr1 = new TableRow();
        TableCell td1 = new TableCell();
        td1.Text = workHistory.ToString();
        td1.ColumnSpan = 2;
        tr1.Cells.Add(td1);
        table.Rows.Add(tr1);
        //table.RenderControl(new HtmlTextWriter(sw));
        return table;
    }

And i am calling this addTableContentWorkHistory(method) inside another GetApplicantInfo(method) where more data are showing inside tooltip
I am adding that too

    public static string GetApplicantInfo(int applicantId)
    {
        //DataSet ds = ApplicantManager.LoadApplicant(applicantId);
        DataTable dtComment = ApplicantManager.GetApplicant(applicantId);

        DataTable dtCurrentPostion = ApplicantManager.GetCurrentPosition(applicantId);

        //work history tooltip
        

        // int applicantId = Convert.ToInt32(dtComment.Rows[0]["ApplicantID"]);
        string applicantInfo = "";
        if (dtComment != null && dtComment.Rows.Count > 0)
        {
            using (StringWriter sw = new StringWriter())
            {
                Table table = new Table();
                //string header = "<br /> <b> ------------------------------------------</b><br />";
                string header = "";
                header = header + "<b> Applicant Information" + "</b> <br />";
                TableRow row = new TableHeaderRow();
                TableCell td1 = new TableCell();
                row.TableSection = TableRowSection.TableHeader;
                td1.Text = header;
                row.Cells.Add(td1);
                table.Rows.Add(row);

                string CreatedDate = dtComment.Rows[0]["CreatedDate"] != null && dtComment.Rows[0]["CreatedDate"].ToString().Length > 0 ?
                    string.Format("{0:MM-dd-yyyy}", DateTime.Parse(dtComment.Rows[0]["CreatedDate"].ToString()))
                    : "-";
                addTableContent(table, " Created On: ", CreatedDate);

                string CurrentPosition = "-";
                if (dtCurrentPostion != null && dtCurrentPostion.Rows.Count > 0)
                {
                     CurrentPosition = dtCurrentPostion.Rows[0]["PositionName"] != null && dtCurrentPostion.Rows[0]["PositionName"].ToString().Length > 0 ? dtCurrentPostion.Rows[0]["PositionName"].ToString() : "-";
                }
                addTableContent(table, " Current Position: ", CurrentPosition);


                string StreetAddress = dtComment.Rows[0]["StreetAddress"] != null && dtComment.Rows[0]["StreetAddress"].ToString().Length > 0 ? dtComment.Rows[0]["StreetAddress"].ToString() : "-";
                addTableContent(table, " Address: ", StreetAddress);


                string ZipCode = dtComment.Rows[0]["ZipCode"] != null && dtComment.Rows[0]["ZipCode"].ToString().Length > 0 ? dtComment.Rows[0]["ZipCode"].ToString() : "-";
                addTableContent(table, " Zip Code: ", ZipCode);

                string Town = dtComment.Rows[0]["Town"] != null && dtComment.Rows[0]["Town"].ToString().Length > 0 ? dtComment.Rows[0]["Town"].ToString() : "-";
                addTableContent(table, " Town: ", Town);

                string StateName = dtComment.Rows[0]["StateName"] != null && dtComment.Rows[0]["StateName"].ToString().Length > 0 ? dtComment.Rows[0]["StateName"].ToString() : "-";
                addTableContent(table, " State: ", StateName);

                string County = dtComment.Rows[0]["County"] != null && dtComment.Rows[0]["County"].ToString().Length > 0 ? dtComment.Rows[0]["County"].ToString() : "-";
                addTableContent(table, " County: ", County);

                #region Country
                int Countryid = dtComment.Rows[0]["CountryId"] != null && dtComment.Rows[0]["CountryId"].ToString().Length > 0 ? Int32.Parse(dtComment.Rows[0]["CountryId"].ToString()) : 0;
                string strCountry = "-";
                if (Countryid > 0)
                {
                    DataTable dtCountry = Common.GetCountries(Countryid);
                    strCountry = dtCountry.Rows[0]["CountryName"] != null && dtCountry.Rows[0]["CountryName"].ToString().Length > 0 ? dtCountry.Rows[0]["CountryName"].ToString() : "-";
                }
                addTableContent(table, " Country: ", strCountry);
                #endregion

                #region Language
                DataTable dtLanguage = ApplicantManager.GetApplicantLanguages(applicantId);
                string strlanguage = "";
                if (dtLanguage.Rows.Count > 0)
                {
                    string language = "";
                    foreach (DataRow r in dtLanguage.Rows)
                    {
                        if (language.Length > 0)
                        {
                            language = language + ",";
                        }
                        language = language + r["Name"].ToString();
                    }
                    strlanguage = language;
                }
                addTableContent(table, " Spoken Language: ", strlanguage);
                #endregion
                DataTable dtPhones = ApplicantManager.GetApplicantPhones(applicantId);
                List<String> types = new List<String>();
                types.Add(ApplicantTelephoneType.MobileCell);
                // string lblMobile = GetApplcantPhones(dtPhones, types);
                string lblMobile = Utility.GetPhoneNumber(dtPhones, ApplicantTelephoneType.MobileCell, Utility.PhoneFormat);
                types.Clear();

                types.Add(ApplicantTelephoneType.TelephoneHome);
                //string lblPhonePersonal = GetApplcantPhones(dtPhones, types);
                string lblPhonePersonal = Utility.GetPhoneNumber(dtPhones, ApplicantTelephoneType.TelephoneHome, Utility.PhoneFormat);
                types.Clear();
                //types.Add("pager");
                types.Add(ApplicantTelephoneType.Pager);
                //string lblPagerNo = GetApplcantPhones(dtPhones, types);
                string lblPagerNo = Utility.GetPhoneNumber(dtPhones, ApplicantTelephoneType.Pager, Utility.PhoneFormat);
                types.Clear();
                //types.Add("fax");
                types.Add(ApplicantTelephoneType.Fax);
                //string lblFaxNo = GetApplcantPhones(dtPhones, types);
                string lblFaxNo = Utility.GetPhoneNumber(dtPhones, ApplicantTelephoneType.Fax, Utility.PhoneFormat);

                DataTable dt = ApplicantManager.GetApplicantEmails(applicantId);
                string lblEmail = dt.Rows.Count == 0 ? "-" : dt.Rows[0].Field<string>("EmailAddress");
                if (lblEmail.Length > 2)
                {
                    //lblEmail = String.Format("<a href=\"/UMRRecruitment/ApplicantManagement/SendOut.aspx?ApplicantID={0}\" target=\"_blank\">{1}</a>", applicantId, lblEmail);
                    //lblEmail = String.Format("<script>onClick=openEmailWindow({0})</script> {1}", applicantId, lblEmail);
                    if (CanManageUserMailConfiguration)
                    {
                        lblEmail = String.Format("<a href=\"javascript:openEmailWindow({0});\">{1}</a>", applicantId, lblEmail);
                    }
                }

                #region location Phone
                string locationPhone = "";
                DataTable whCurrentDt = ApplicantManager.GetContinuingWorkHistorys(applicantId, true);
                if (whCurrentDt != null && whCurrentDt.Rows.Count > 0)
                {
                    string s = "";
                    for (int i = 0; i < whCurrentDt.Rows.Count; i++)
                    {
                        DataRow r = whCurrentDt.Rows[i];
                        int? instituteID = null;
                        if (r["InstituteID"] != DBNull.Value)
                        {
                            instituteID = Convert.ToInt32(r["InstituteID"]);
                        }
                        int? positionId = null;
                        if (r["PositionID"] != DBNull.Value)
                        {
                            positionId = Convert.ToInt32(r["PositionID"]);
                        }
                        string location = string.Empty;
                        if (Convert.ToString(r["ClinicalArea"]) != null)
                        {
                            location = Convert.ToString(r["ClinicalArea"]);
                        }

                        DataTable dtLocationPhones = null;

                        if (instituteID.HasValue && positionId.HasValue && location.Length > 0)
                        {
                            dtLocationPhones = InstitutionManager.GetInstitutionPhone(InstitutionTelephoneType.LocationPhoneNumber, instituteID.Value, positionId.Value, location);
                        }

                        if (i > 0)
                        {
                            if (dtLocationPhones != null && dtLocationPhones.Rows.Count > 0 && !string.IsNullOrEmpty(s))
                            {
                                s = s + "<br/>";
                            }
                        }

                        if (dtLocationPhones != null && dtLocationPhones.Rows.Count > 0)
                        {
                            s = s + PageBase.GetLocationPhoneWithExtension(dtLocationPhones);
                        }
                    }
                    locationPhone = s;
                }
                else
                {
                    DataTable whDt = ApplicantManager.GetContinuingWorkHistorys(applicantId, false);
                    if (whDt != null && whDt.Rows.Count > 0)
                    {
                        string s = "";
                        for (int i = 0; i < whDt.Rows.Count; i++)
                        {
                            DataRow r = whDt.Rows[i];
                            int? instituteID = null;
                            if (r["InstituteID"] != DBNull.Value)
                            {
                                instituteID = Convert.ToInt32(r["InstituteID"]);
                            }
                            int? positionId = null;
                            if (r["PositionID"] != DBNull.Value)
                            {
                                positionId = Convert.ToInt32(r["PositionID"]);
                            }
                            string location = string.Empty;
                            if (Convert.ToString(r["ClinicalArea"]) != null)
                            {
                                location = Convert.ToString(r["ClinicalArea"]);
                            }


                            DataTable dtLocationPhones = null;

                            if (instituteID.HasValue && positionId.HasValue && location.Length > 0)
                            {
                                dtLocationPhones = InstitutionManager.GetInstitutionPhone(InstitutionTelephoneType.LocationPhoneNumber, instituteID.Value, positionId.Value, location);
                            }

                            if (i > 0)
                            {
                                if (dtLocationPhones != null && dtLocationPhones.Rows.Count > 0 && !string.IsNullOrEmpty(s))
                                {
                                    s = s + "<br/>";
                                }
                            }
                            if (dtLocationPhones != null && dtLocationPhones.Rows.Count > 0)
                            {
                                s = s + PageBase.GetLocationPhoneWithExtension(dtLocationPhones);
                            }
                        }
                        locationPhone = s;
                    }
                }
                #endregion
                addTableContent(table, " Mobile Number: ", lblMobile);
                addTableContent(table, " Home Number: ", lblPhonePersonal);
                addTableContent(table, " Department Phone Number: ", locationPhone);
                addTableContent(table, " Pager Number: ", lblPagerNo);
                addTableContent(table, " Fax Number: ", lblFaxNo);
                addTableContent(table, " E-Mail: ", lblEmail);
                string recruiterName = "-";
                int PrimaryOwnerID = Int32.Parse(dtComment.Rows[0]["PrimaryOwnerID"].ToString());
                DataTable dtUser = UserManager.GetUser(PrimaryOwnerID);
                if (dtUser.Rows.Count > 0)
                {
                    recruiterName = dtUser.Rows[0]["FirstName"].ToString() + " " + dtUser.Rows[0]["LastName"].ToString();
                }
                addTableContent(table, " Recruiter : ", recruiterName);
                table.RenderControl(new HtmlTextWriter(sw));
                applicantInfo = applicantInfo + sw.ToString();


                int? applicantType = (int)ApplicantCommentStatus.Employee;
                string orders = "WH.PositionName,APP.ApplicantName,ST.StateName,App.Town";

                DataTable dtSC = UserManager.GetUserSettingsByUserID(UtilityUserId);
                int criteria = Convert.ToInt32(dtSC.Rows[0]["Search_Match_Criteria"]);

                DataTable dtWH = ApplicantManager.GetBasicApplicantViewDetail(20, 0, applicantId.ToString(), false, string.Empty, string.Empty, string.Empty,
                                                                  null, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, false, false,
                                                                  null, applicantType, orders,
                                                                  criteria, string.Empty, null, null, null, null, string.Empty, null,
                                                                  null, string.Empty, string.Empty, null, null, 0, null, null, null, string.Empty, string.Empty, string.Empty, null, null, null, string.Empty, null, string.Empty, string.Empty).Tables[1];
                addTableContentWorkHistory(table, dtWH);
                //table.RenderControl(new HtmlTextWriter(sw));
                //applicantInfo = applicantInfo + addTableContentWorkHistory(table, dtWH);

            }
            


        }
        return applicantInfo;
    }

Please you can ask me any info you want. So my query is here what i need to do next to show data thru addTableContentWorkHistory

- Reply
XuDong Peng
Contributor

2400 Points

752 Posts
Re: showing html table data in tooltip

Jun 29, 2020 10:06 AM|XuDong Peng|LINK
Hi mazharul007,

Do you mean that you don’t know how to display the value you want to set in the tooltip in the table?

If this is the case, you could achieve your needs by setting the title attribute of the cell in table, like this:
```
TableCell cell = new TableCell();
cell.Text = "some txt";
cell.Attributes.Add("title", "you want to set");
```
Result:

You could also refer to below cases:

ToolTip for Table cell ASP.NET

Display additional information in Tool tip on Mouse over of record in MVC Table

Best regards,

Xudong Peng
ASP.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today. Learn more >
- Reply
mazharul007
Member

12 Points

42 Posts

Re: showing html table data in tooltip

Jun 29, 2020 12:14 PM|mazharul007|LINK

Hello Peng,

Thanks i have solved the issue but can you tell me that how to add the Table Title above the table in asp.net using c#?

Such as , if you consider the previous example I want to add a Table Name above the table how can i do that?

XuDong Peng

Contributor

2400 Points

752 Posts

Re: showing html table data in tooltip

Jun 30, 2020 02:13 AM|XuDong Peng|LINK

Hi mazharul007,

If you want to add a title to the table, I think using TableHeaderRow class to achieve is a good way.

A simple example:

protected void Page_Load(object sender, EventArgs e)
        {
            Table table = new Table();
            // table title
            TableHeaderRow headerRow = new TableHeaderRow();
            TableHeaderCell headerCell = new TableHeaderCell();
            headerCell.Text = "This is title";
            headerCell.ColumnSpan = 2;
            headerRow.BackColor = Color.LightBlue;
            headerRow.Cells.Add(headerCell);
            table.Rows.Add(headerRow);
            table.Rows[0].Cells[0].Attributes.Add("style", "text-aglin:center !important;");
            // table body
            for (var i = 0; i < 3; i++)
            {
                TableRow row = new TableRow();
                for (var j = 0; j < 2; j++)
                {
                    TableCell cell = new TableCell();
                    cell.Text = "some txt" + i.ToString() + j.ToString();
                    row.Cells.Add(cell);
                    cell.Style.Add("border", "green 1px solid");
                }
                table.Rows.Add(row);
            }
            table.CellSpacing = 0;
            Page.Controls.Add(table);
        }

Result:

More details, you could refer to this document.

Best regards,

Xudong Peng

ASP.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today. Learn more >

- Reply
asteranup
All-Star

20953 Points

4984 Posts

Re: showing html table data in tooltip

Jul 01, 2020 01:00 PM|asteranup|LINK

Hi mazharul007,

May I ask you a question? Why you are building an HTML table in C#. This looks to be tabular data. You can easily use a repeater control if you are using webform. If you are using anything other than that you can easily use JavaScript/jQuery to easily create such HTML. It's not a good idea to hardcode HTML tags in C#. Any change in your HTML, you need to change C# code.

Thanks,
Anup Das Gupta
Visit My Blog
You can also connect with me in LinkedIn

‹ Previous Thread|Next Thread ›