How Do I Apply Validation To Form

Question

1.00/5 (1 vote)

See more:

Hi,

I have a requirement where i need to do Find and Replace in datagridview for multiple pages - It's working fine.
The problem is, after i Find a specific word and replace it and again if i click on Find and Replace button, the earlier find and replace values are gone.

How to work on it?

Posted 13-Jan-16 23:08pm

Member 8010354

Add a Solution

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)

Sri Nivas (Vasu) · Accepted Answer · 2016-01-13T23:29:00

Solution 1

If you need to save the find and replace values you need to store the corresponding values to database. I think find and replace values are not storing in the database that's why you are not getting previous replaced values. If you don't want to save to database then you need to store the find and replace values in cookie and each post back you need to replace values of all the values in cookie.

Posted 13-Jan-16 23:29pm

Sri Nivas (Vasu)

Comments

Member 8010354 14-Jan-16 6:03am

Thank you. But i'm working on windows application and i'm not fetching data from any database. I'm reading a file and displaying in datagridview.
In this case, how should i save it? shall i post my code so it'll be helpful?

Sri Nivas (Vasu) 14-Jan-16 6:50am

Yes, that will be helpful.

Member 8010354 14-Jan-16 6:55am

public string toFind = ""; public string toReplace = "";
private void btnFindandReplace_Click(object sender, EventArgs e)
{
Form2 f = new Form2();
f.cmbColumnCombo.DataSource = cmbList;
f.ShowDialog();
toFind = f.txtfind.Text;
toReplace = f.txtreplace.Text;
for (int i = 0; i <= dataGridView1.Rows.Count - 1; i++)
{
if (dataGridView1.Rows[i].Cells[f.cmbColumnCombo.Text].Value.ToString().ToLower().Contains(f.txtfind.Text.ToLower()))
{
if (!string.IsNullOrEmpty(f.txtfind.Text))
{
dataGridView1.Rows[i].Cells[f.cmbColumnCombo.Text].Value = dataGridView1.Rows[i].Cells[f.cmbColumnCombo.Text].Value.ToString().Replace(f.txtfind.Text, f.txtreplace.Text);
}
}
}
}

Sri Nivas (Vasu) 14-Jan-16 7:32am

Can you please provide the code for dataGridView1 binding ?

Member 8010354 14-Jan-16 8:24am

BRWSE button code where i read the file into DataGridView:

private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();

openFileDialog1.InitialDirectory = "Desktop";
openFileDialog1.Filter = "dat files (*.DAT)|*.DAT|All files (*.*)|*.*";
openFileDialog1.FilterIndex = 2;
openFileDialog1.RestoreDirectory = true;

if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
try
{
FileName = openFileDialog1.FileName;
string text = System.IO.File.ReadAllText(FileName);
datfile = text.Split(new string[] { "\r\n", "\n" }, StringSplitOptions.None);
//Added on 2015-12-02
maxRec = datfile.Length - 1;
PageCount = maxRec / pageSize;
LoadPage(MyFOrmat);
}
catch (Exception ex)
{
MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message);
}
}
}

Sri Nivas (Vasu) 14-Jan-16 8:34am

If I understand correctly,
1) Form will loads with out data.
2) Upon clicking button1 data will be loaded in the form.
3) Upon clicking btnFindandReplace button you are replacing the data grid data

If these are the steps then replace should work properly, why because you are replacing the what ever grid data you are replacing.

I think some where grid is reloading, which will causing the lost of previous loaded data. with the code you have provided I am not able to point that point where grid is reloading.

Please Identify you are not loading the grid in the form load or some where else, put debug point all the places where you are loading the grid and remove the unnecessary loading. This will solve the problem.

Member 8010354 18-Jan-16 2:10am

Hi, Yeah what you understood is correct in terms of Data Loading and Gridview loading multiple time. Whenever i click NEXT button, the loads and will fetch the rest of the documents (Which is continuous from the previous page line).

Here's the LoadPage code:
public void LoadPage(string Format, bool isFindAndReplace = false)
{
int startRec;
int endRec;

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

dataGridView1.Rows.Clear();
if (recNo == 0)
{
dataGridView1.Columns.Clear();
}
int rowindex = 0;
startRec = recNo;
for (int RowCount = startRec; RowCount <= endRec; RowCount++)
{
if (datfile[RowCount].ToString() != "")
{
if (RowCount == 0)
{
string[] column = datfile[RowCount].Split('þ');
for (int i = 0; i < column.Length - 1; i++)
{
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]);
i += 1;
}
}
}

if (RowCount != 0)
{
dataGridView1.Rows.Add();
string[] column = datfile[RowCount].Split('þ');
int index = 0;
for (int i = 1; i < 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
{
if (toFind != "" && toReplace != "")
{
if (column[i].Contains(toFind))
{
//dataGridView1.Rows[i].Cells[f.cmbColumnCombo.Text].Value = dataGridView1.Rows[i].Cells[f.cmbColumnCombo.Text].Value.ToString()
column[i] = column[i].Replace(toFind, toReplace);
dataGridView1.Rows[rowindex].Cells[index].Value = column[i].Trim('þ');
}
else
{
dataGridView1.Rows[rowindex].Cells[index].Value = column[i].Trim('þ');
}
}
else
{
dataGridView1.Rows[rowindex].Cells[index].Value = column[i].Trim('þ');
}
}
index += 1;
i += 1;
}
}
rowindex += 1;
}
}
recNo += 1;
}
}

Sri Nivas (Vasu) 18-Jan-16 4:27am

Issue solved, Cool. Apart from that better to move the the code in the
LoadPage() method to other methods and call those methods from LoadPage() it will be good to maintain and understand the flow.

BillWoodruff 15-Jan-16 3:03am

+5 Nice to see patient dialog with OP.

Sri Nivas (Vasu) 18-Jan-16 4:27am

Thanks :)