c# - How to join two lists and fill a datagridview -

-

i have 2 list (1st values website, 2nd values .csv file) , i'd join them in list, starting 2 equals values, , display in datagridview.

before post code, i'd tried fill datagridview these 2 lists separately , work.

i didn't error, can't see datagridview values.

i'm going post code , explain it.

first list code:

var url = textbox5.text;         //var url = "http://www.betexplorer.com/soccer/norway/tippeligaen/results/";          var web = new htmlweb();         var doc = web.load(url);          bets = new list<bet>();            // lettura delle righe         var rows = doc.documentnode.selectnodes("//tr");          foreach (var row in rows)         {             if (!row.getattributevalue("class", "").contains("rtitle"))             {                 if (string.isnullorempty(row.innertext))                     continue;                  var rowbet = new bet();                 foreach (var node in row.childnodes)                 {                     var data_odd = node.getattributevalue("data-odd", "");                      if (string.isnullorempty(data_odd))                     {                         if (node.getattributevalue("class", "").contains("first-cell"))                         {                             rowbet.match = node.innertext.trim();                             var matchteam = rowbet.match.split(new[] { " - " }, stringsplitoptions.removeemptyentries);                             rowbet.home = matchteam[0];                             rowbet.host = matchteam[1];                         }                           if (node.getattributevalue("class", "").contains("result"))                         {                             rowbet.result = node.innertext.trim();                             var matchpoints = rowbet.result.split(new[] { ':' }, stringsplitoptions.removeemptyentries);                             int help;                             if (int.tryparse(matchpoints[0], out help))                             {                                 rowbet.homepoints = help;                             }                             if (matchpoints.length == 2 && int.tryparse(matchpoints[1], out help))                             {                                 rowbet.hostpoints = help;                             }                          }                           if (node.getattributevalue("class", "").contains("last-cell"))                             rowbet.date = node.innertext.trim();                      }                     else                     {                         rowbet.odds.add(data_odd);                     }                 }                  if (!string.isnullorempty(rowbet.match))                     bets.add(rowbet);             }         }

second list & combined list code:

 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 * " + path.getfilename(filename), conn);      dataset ds = new dataset("temp");     adapter.fill(ds);      conn.close();      // datatable dt = new datatable();     datatable dt = ds.tables[0];      //datagridview2.datasource = dt;     // datagridview2.datamember = "table";       list<ht> matchlist = new list<ht>();     matchlist = (from datarow dr in dt.rows                    select new ht()                    {                        home = dr["home"].tostring().replace("milan", "ac milan").replace("roma", "as roma"),                        host = dr["host"].tostring().replace("milan", "ac milan").replace("roma", "as roma"),                        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 = matchlist;      var combineddatalist = (from d1 in bets                             //join d2 in datalist2 on d1.home equals d2.home                             join d2 in matchlist on new { d1.home, d1.host } equals new { d2.home, d2.host }                              select new combineddata                             {                                 data = d1.date,                                 home = d1.home,                                 away = d1.host,                                 hsft = d1.homepoints,                                 asft = d1.hostpoints,                                 hsht = d2.scorehome,                                 asht = d2.scoreaway,                                 hodd = d1.odd1,                                 xodd = d1.oddx,                                 aodd = d1.odd2,                                 risfin = d1.risfin,                                 over05sh = d1.over05sh,                                 over05ft = d1.over05ft,                                 over15ft = d1.over15ft,                                 over25ft = d1.over25ft,                                 over35ft = d1.over35ft,                                 over45ft = d1.over45ft                               }).orderby(p => p.hodd);     datagridview2.datasource = combineddatalist;

thank attention. have fantastic sunday!

edit: delete unnecessary code

edit2: add screen of single list output. let's see:

first list: enter image description here

second list:

enter image description here

so, i'd merge "scorehome" , "scoreaway" second list in first list based on "home" , "host" have in both lists.


Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more