How to replace strings in a List

Question

I got values from a .csv file and put them into a datagridview, but I'd like to replace some values before to fill my datagridview.

This is the screen of my .csv file:

and this is my code to try to do it:

string FileName = @"C:\mydir\testcsv.csv";
    OleDbConnection conn = new OleDbConnection
           ("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " +
             Path.GetDirectoryName(FileName) +
             "; Extended Properties = \"Text;HDR=YES;FMT=Delimited\"");

    conn.Open();

    OleDbDataAdapter adapter = new OleDbDataAdapter
           ("SELECT * FROM " + Path.GetFileName(FileName), conn);

    DataSet ds = new DataSet("Temp");
    adapter.Fill(ds);

    conn.Close();

    DataTable dt = ds.Tables[0];

    List<HT> matchhtList = new List<HT>();
    matchhtList = (from DataRow dr in dt.Rows
                   select new HT()
                   {
                       Home = dr["Home"].ToString(),
                       Away = dr["Away"].ToString(),
                       ScoreHome = dr["ScoreHome"].ToString(),
                       ScoreAway = dr["ScoreAway"].ToString(),
                       Segno = dr["Segno"].ToString(),
                       odd1 = dr["odd1"].ToString(),
                       oddx = dr["oddx"].ToString(),
                       odd2 = dr["odd2"].ToString()

                   }).ToList();

    StringBuilder mystring = new StringBuilder("matchhtList");
    mystring = mystring.Replace("Rosenborg", "Rihanna")
           .Replace("Start", "Stop")
           .Replace("Brann", "Circus");

    dataGridView2.DataSource = mystring;

Please, if my question is not clear, tell me before to put "-1", I'll try to explain better my question. Thank you very much!

You likely had the downvote due to "but its not working". What precisely isn;t working? is there an exception etc. This is the detail thats missing. — Darren Wainwright
– Darren Wainwright, Commented Nov 11, 2016 at 15:39
As it happens, you're setting your datasource to a string - not your actual data.... — Darren Wainwright
– Darren Wainwright, Commented Nov 11, 2016 at 15:40
ok, I made a mistake, but please don't give me a downvote, just for this time. I deleted the wrong question... — Marci
– Marci, Commented Nov 11, 2016 at 15:49
I didn;t downvote - not my style :) just giving reasons why you might have been. — Darren Wainwright
– Darren Wainwright, Commented Nov 11, 2016 at 15:50

Damith · Accepted Answer · 2016-11-11 15:46:14Z

2

you can replace the the text when you build the list

matchhtList = (from DataRow dr in dt.Rows
                   select new HT()
                   {
                       Home = dr["Home"].ToString().Replace("Rosenborg", "Rihanna"),
                       Away = dr["Away"].ToString().Replace("Start", "Stop").Replace("Brann", "Circus"),
                       ScoreHome = dr["ScoreHome"].ToString(),
                       ScoreAway = dr["ScoreAway"].ToString(),
                       Segno = dr["Segno"].ToString(),
                       odd1 = dr["odd1"].ToString(),
                       oddx = dr["oddx"].ToString(),
                       odd2 = dr["odd2"].ToString()

                   }).ToList();

dataGridView2.DataSource = matchhtList;

edited Nov 11, 2016 at 15:46

answered Nov 11, 2016 at 15:39

Damith

63.2k13 gold badges106 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

R R · Accepted Answer · 2016-11-11 15:39:48Z

0

you can manipulate the values in rowdatabound event of gridview

https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.rowdatabound(v=vs.110).aspx

And your datasource must be a List or DataTable in above scenario.

dataGridView2.DataSource = mystring;//Wrong

should be

dataGridView2.DataSource = matchList;

answered Nov 11, 2016 at 15:39

R R

2,9562 gold badges27 silver badges43 bronze badges

Collectives™ on Stack Overflow

How to replace strings in a List

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related