Message Box for the replaced count

Question

1.00/5 (1 vote)

See more:

Hi,

I have a task called Find and Replace in the DataGridView - It's completed.But i want the replaced count in the message box.

Can anyone help me how to achieve this? Below is my Find and Replace code:

C#

private void btnFindandReplace_Click(object sender, EventArgs e)
        {
            f.cmbColumnCombo.DataSource = cmbList;
            f.ShowDialog();

                        if (recNo &gt; 0)
                            recNo = recNo - 30;
                        LoadPage(MyFOrmat, true);
}
 public void LoadPage(string Format, bool isFindAndReplace = false)
        {
            int startRec;
            int endRec;

            if (currentPage == PageCount)
            {
                endRec = (int)maxRec;
            }
            else
            {
                endRec = (int)pageSize * currentPage;
            }

            dataGridView1.Rows.Clear();
            if (recNo == 0)
            {
                dataGridView1.Columns.Clear();
            }

            int rowindex = 0;
            startRec = recNo;
            for (int RowCount = startRec; RowCount &lt;= endRec; RowCount++)
            {
                if (datfile[RowCount].ToString() != "" )
                {
                    if (RowCount == 0)
                    {
                        string[] column = datfile[RowCount].Split('þ');
                        for (int i = 0; i &lt; column.Length - 1; i++)
                        {
                            if (column[i].ToString() != "") //if (column[i].ToString() != "" && column[i].ToString() != "\u0014")
                            {
                                DataGridViewTextBoxColumn dgvtxtcountry = new DataGridViewTextBoxColumn();
                                dgvtxtcountry.HeaderText = column[i].ToString();
                                dgvtxtcountry.Name = column[i].ToString();
                                dataGridView1.Columns.Add(dgvtxtcountry);
                                cmbList.Add(column[i]);
                                // dataGridView1.Columns["Sent Date"].DefaultCellStyle.Format = "dd/MM/yyyy";
                                i += 1;
                            }
                        }
                    }

                    if (RowCount != 0)
                    {
                        dataGridView1.Rows.Add();
                        string[] column = datfile[RowCount].Split('þ');
                        int index = 0;
                        for (int i = 1; i &lt; column.Length - 1; i++)
                        {
                            if (column[i].ToString() != "\u0014")
                            {
                                //if (i == 3)
                                //{
                                //    dataGridView1.Rows[rowindex].Cells[index].Value = Convert.ToDateTime(column[i]).ToString(Format);
                                //}
                                //else
                                //{ 
                                    dataGridView1.Rows[rowindex].Cells[index].Value = column[i].Trim('þ'); 
                                //}

                                if (StaticVar.FnR == true && index == StaticVar.colindx)
                                {

                                    if ((column[i]).Contains(StaticVar.Find) != null)
                                        dataGridView1.Rows[rowindex].Cells[index].Value = column[i].Replace(StaticVar.Find, StaticVar.Replace);
                                }
                                if (StaticVar.DateFormat != "" && StaticVar.DateFormat != null)
                                {
                                    if (StaticVar.datecolidx == ((i - 1) / 2))
                                    {
                                        dataGridView1.Rows[rowindex].Cells[index].Value = Convert.ToDateTime(column[i]).ToString(StaticVar.DateFormat);
                                    }
                                }
                                
                                index += 1;
                                i += 1;
                            }
                        }
                        rowindex += 1;
                    }
                }
                recNo += 1;
                //IsDateFormatted = false;
            }
        }

Posted 29-Jan-16 0:44am

Member 8010354

Updated 29-Jan-16 0:58am

F-ES Sitecore

v2

Add a Solution

Comments

Richard MacCutchan 29-Jan-16 7:17am

Where is this value saved?

Sinisa Hajnal 29-Jan-16 7:19am

Just increase some variable on each replace and save it somewhere where you can call it after the replace is done.

Member 8010354 29-Jan-16 8:07am

Thank you:)

ZurdoDev 29-Jan-16 8:05am

Sinisa said it. This is very, very easy to do. Where are you stuck?

Member 8010354 29-Jan-16 8:07am

Working on it.

Member 8010354 1-Feb-16 2:41am

In this line, i'm replacing my text.

if (StaticVar.FnR == true && index == StaticVar.colindx)
{

if ((column[i]).Contains(StaticVar.Find) != null)
dataGridView1.Rows[rowindex].Cells[index].Value = column[i].Replace(StaticVar.Find, StaticVar.Replace);
}
so i would like to add message boc after replacing the values.

Member 8010354 1-Feb-16 7:06am

I got it by this way:
if (isFindAndReplace)
{
MessageBox.Show(string.Format("No: of values replaced is: {0}", replaced));
}

ZurdoDev 1-Feb-16 7:17am

Glad you worked it out on your own. Trust me, you'll learn a lot more as you do that. Please post this as a solution so that this no longer shows as unanswered.

Member 8010354 2-Feb-16 4:20am

I stuck in another functionality here. After clicking on find and replace, i'm getting a message box. After closing the window also i'm getting the same message box (Everytime). How to resolve this?

ZurdoDev 2-Feb-16 7:06am

Debug your code. Why are you getting a messagebox when you close the form?

BillWoodruff 31-Jan-16 2:48am

Why aren't you:

1. transforming your DataFile into a DataTable, or some other form, and using binding ?

2. then, search and replace, in the DataTable, and refresh the DataGridView by re-setting its DataSource to the changed DataTable.

Member 8010354 31-Jan-16 23:53pm

If i take that in datable, it'll some time to load the file. so i'm reading th efile.

Member 8010354 1-Feb-16 7:06am

I got it by this way:
if (isFindAndReplace)
{
MessageBox.Show(string.Format("No: of values replaced is: {0}", replaced));
}

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)

Member 8010354 · Answer 1 · 2016-02-01T22:18:00

Solution 1

I got it by this way:
if (isFindAndReplace)
{
MessageBox.Show(string.Format("No: of values replaced is: {0}", replaced));
}

Posted 1-Feb-16 22:18pm

Member 8010354