to Precise the data in cell of grid.

Question

0.00/5 (No votes)

See more:

In the Cell of grid i am having data

SR-233546/assigned , SR-656756/New

What i want the data along with slash should not appear in cell It shuold appear this way
SR-533546 so how can i trim the data.

second thing is on mouse hover it should show that following id"SR-53346" is in process or isCompleted

can you guide me what should i code?

Posted 16-Sep-13 23:20pm

hira_1

Add a Solution

Comments

[no name] 17-Sep-13 5:27am

"can you guide me what should i code", sure... learn about the String class and how to create a tooltip.

1 solution

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)

Harshil_Raval · Accepted Answer · 2013-09-16T23:30:00

Solution 1

Hi, you can achieve it in RowDataBound event of gridview.

C#

protected void YourGrid_RowDataBound(object sender, GridViewRowEventArgs e)
{
      if (e.Row.RowType == DataControlRowType.DataRow)
      {
            // suppose you are storing your required value in label.
            Label lbl = (Label)e.Row.FindControl("LabelID");
            string[] value = lbl.Text.Split('/');
            if(value.Length > 0)
            {
                  lbl.Text = value[0];
            }
            lbl.ToolTip = your value; //in process or iscompleted
      }
}

Hope it helps you.
Thanks.

Posted 16-Sep-13 23:30pm

Harshil_Raval

Comments

hira_1 17-Sep-13 6:53am

i tried see :It is a link button.. I did this:

string value = LnkMSid.Text.Split('/').ToString();

if (value.Length > 0) {

LnkMSid.Text = value[0].ToString(); }

i got this out put S

Harshil_Raval 17-Sep-13 6:55am

So, you got currect output?

hira_1 17-Sep-13 7:13am

No :( ... output should be.. SR-1212323 or IN-65877678 ... these are actually the id's

Harshil_Raval 17-Sep-13 7:18am

Hi,
string value = LnkMSid.Text.Split('/').ToString();
if (value.Length > 0) {
LnkMSid.Text = value[0].ToString();
}
You have posted this code in comment. But this is not right. It should be
string[] value = LnkMSid.Text.Split('/');
if (value.Length > 0) {
LnkMSid.Text = value[0].ToString();
} Check by implementing this code. It should give you your desire result. Say for example your string="SR-1212323/assigned". Then after split, string value will be SR-1212323.

hira_1 17-Sep-13 7:45am

ok i am checking it agian
Thank you :)

hira_1 17-Sep-13 7:51am

OOhhh Wow Thank you so Much I get the Result :)

hira_1 17-Sep-13 7:56am

8/3/2013 9:28:48 AM kci.yfpb97: Agent Name : Naeem Faiz User ID : naeem.faiz Email : lhr.yfpb4@ubl.com.pk SOF form is attached for your refrence by Rizwan Ahmed NOTE : email is not listed in affected user list. 8/3/2013 9:42:01 AM it.hd8: 8/3/2013 9:28:48 AM kci.yfpb97: Agent Name : Naeem Faiz User ID : naeem.faiz Email : lhr.yfpb4@ubl.com.pk SOF form is attached for your refrence by Rizwan Ahmed NOTE : email is not listed in affected user list. (Recorded as a Service Request) Service Request No: SR-233515 By:it.hd8 On:8/3/2013 9:42:01 AM 8/3/2013 9:42:11 AM it.hd8: (Service Request In Progress) Service Request No: SR-233515 Additional Remarks:

One more help :
The above is the text appearing in column of grid. How can i make this trim ??

Harshil_Raval 17-Sep-13 8:04am

Sorry, but from your this comment, i can't get what you want exactly, please reformat your comment.

hira_1 17-Sep-13 8:10am

I am trying to say that there in grid a cells containing that huge data ... how can i trim that?

Harshil_Raval 17-Sep-13 8:14am

Ohh!! This whole string can not be trim. How this complex value is binding in gridview? Stop binding this. And display it in different column, like Date, AgentName, Email etc.. Hope you got me..

hira_1 17-Sep-13 8:20am

Yes i did ... but i have been asked too bind this data to the column name "userQueryRequest"

So if it would be possible to trim rest data can show up by using tool tip :)

hira_1 17-Sep-13 8:14am

if (LblMN.Text == "Incident")
{

if (LblURS.Text=="New")
{
int iStart = LnkMSid.Text.IndexOf("Incident is New");

GridView1.Rows[i].Cells[4].Attributes.Add("Style", "background: url(../Images/flag_blue.gif) no-repeat;" + LnkMSid.Text.Substring(iStart + 1));
}
else if (LblURS.Text == "Resolved")
{
int iStart = LnkMSid.Text.IndexOf("Incident has been Resolved");
GridView1.Rows[i].Cells[4].Attributes.Add("Style", "background: url(../Images/flag_orange.gif) no-repeat;" + LnkMSid.Text.Substring(iStart + 1));
}
else if (LblURS.Text == "Closed")
{
int iStart = LnkMSid.Text.IndexOf("Incident is Closed");
GridView1.Rows[i].Cells[4].Attributes.Add("Style", "background: url(../Images/flag_green.gif) no-repeat;" + LnkMSid.Text.Substring(iStart + 1));
}
else
{
int iStart = LnkMSid.Text.IndexOf("Incident is under progress");
GridView1.Rows[i].Cells[4].Attributes.Add("Style", "background: url(../Images/flag_red.gif) no-repeat;" + LnkMSid.Text.Substring(iStart + 1));
}

Is this code ok can you check and tell.

Harshil_Raval 17-Sep-13 8:23am

No, i think when when you are getting substring value, at that lines you are committing mistakes.
LnkMSid.Text.Substring(iStart + 1) this should be
LnkMSid.Text.Substring(iStart + 1,LnkMSid.Text.Length-1)