Datatable filter using data in app.config and C# app

Question

0.00/5 (No votes)

See more:

Scenario: I have a datatable which fills data into datagrid dynamically/run time as shown below:

C#

dt.Rows.Add(value1, value2, value3, value4, value5, value6, value6, value7, value8);

Now I have data in app.config file which I retrieve as shown below:

C#

// app.config file contains string with comma separated and I am splitting it in code

string num1 = ConfigurationManager.AppSettings["crNum"];
string[] values = num1 .Split(',');

foreach (string crNum in values)
{
    // I need code here to delete the entire rows where value1 == crNum 
    // in my above data table dt and also when I reopen/refresh 
    // my c# application I should not see the row deleted before.
}

Finally I insert the datatable into the grid

C#

myCRGrid.DataSource = dt;

I am new to C#, I apologise for such a weird question.

Please help

Thanks!

What I have tried:

i tried deleting but im not successful, also getting confused to write the code inside the foreach loop

Posted 26-Aug-16 9:34am

Member 12705538

Updated 27-Aug-16 10:59am

Add a Solution

Comments

FranzBe 26-Aug-16 16:06pm

app.config is not expected to hold application data, you should use some .csv file for that; the app.config should only hold the 'configuration' related stuff. It would help understand your question if you post some sample data

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)

FranzBe · Answer 1 · 2016-08-26T10:22:00

asumming that "demodata.csv" looks like this

C#

42,1,2,3,4,5,6,7
43,7,6,5,4,3,2,1
42,2,3,4,5,6,7,8
44,9,8,7,6,5,4,3

i would suggest something like that

C#

void Main()
{
	var records = ProcessMyData(@"c:\temp\demodata.csv");
	
	var filteredRecords =
	       records.Where(x => x.Value1 != "42");
		   
	// now you have the records of the file you want
	// you may assign that without use of a datatable to your grid
	
}

// Define other methods and classes here
class MyData
{
	public string Value1 { get; set; }
	public string Value2 { get; set; }
	public string Value3 { get; set; }

	internal static MyData ParseFromCsv(string line)
	{
		var c = line.Split(',');
		return new MyData
		{
			Value1 = c[0],
			Value2 = c[1],
			Value3 = c[2]
			//....
		};
	}
}


private static List<MyData> ProcessMyData(string path)
{
	return File.ReadAllLines(path)
		.Select(MyData.ParseFromCsv)
		.ToList();
}

Karthik_Mahalingam · Answer 2 · 2016-08-26T18:31:00

Solution 2

try this

C#

foreach (DataRow row in dt.Rows)
       {
           if (values.Contains(row["Value1"].ToString()))
               row.Delete();
       }
       dt.AcceptChanges();

Posted 26-Aug-16 18:31pm

Karthik_Mahalingam

Halit Yurttaş · Answer 3 · 2016-08-27T10:59:00

Ok now try below code. Its remove your value contain rows by founden from select method. Select method is return ICollection<datarow>

C#

string num1 = ConfigurationManager.AppSettings["crNum"];
string[] values = num1 .Split(',');
 
foreach (string crNum in values)
{
    foreach (var nrow in dt.Select("Value1 = " + crNum))
    {
        dt.Rows.Remove(nrow);
    }
}

Datatable filter using data in app.config and C# app

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0