Sv:Hämta data från websida och spara i en access databas?

Hämta data från websida och spara i en access databas?

Postades av 2006-03-14 11:45:04 - Greger Gustavsson, i forum c# (c-sharp), Tråden har 2 Kommentarer och lästs av 1235 personer

Jag håller på att bygga ett program för att få 13rätt på tipset.
Det bygger på att samla information om alla matcher och sedan utföra en regresinsanalays på datat för att få fram vinnande rad.

Någon som har några tips?

Databas tips.mdb
Tabeller
FAKTA datum,matchnr,hemmalag,bortalag,hemmaligakod,bortaligakod,rätttipstecken,osv
LIGA ligakod,Ligatext
SPEL datum,matchnr,tipstecken,antalrader,antalrätt,vinst

Hur hämtar jag data från en websida och sparar det i en access databas?

https://secure.svenskaspel.se//includes/visualElements/flikframes.asp?product=1&info=matchfakta&matchval=1&match=105785&omg=3911

:-)

Svara

Sv: Hämta data från websida och spara i en access databas?

Postades av 2006-03-14 12:00:36 - Tyronne Engström

Hej!

Det blir bökigt!

Eftersom du inte har tillgång till databasen på svenska spel och tänker då läsa av hemsidan du granskar så blir processen följande

1. Hämta en sidan du vill läsa av.
2. Läsa in all kod från sidan, dvs dessamma som att du högerklickar på en sida och väljer visa källa), men du vill i stället få in den i en variabel eller texbox mm för att kunna behandla koden.
3. Filtrerar ut från all html/javakod unika taggar för just den data du vill ha in.
4. Etablera en DB-koppling till access databasen och sedan spara informationen.

Som du märker är detta inte helt enkelt. Bar att få ut allkod är en process för sig. Och sedan när du skall filtrera ut all kod från sidan för att hitta den datan du vill ha är tuft.

Här ex på kod du måste filterar: (detta är koden från sidan du visade i länken oan)

<code>
<STYLE type=text/css>
BODY {margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;}
</STYLE>
<link type='text/css' rel='stylesheet' href='/includes/svsstyles.css'>
<TABLE WIDTH=570 CELLPADDING=0 BORDER=0 CELLSPACING=0>
<TR>
<TD COLSPAN=2 CLASS='lbb'>Stryktipset vecka 11</TD></TR>
<TR>
<TD COLSPAN=2><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=6></TD>
</TR>
<TR>
<TD COLSPAN=2>
<TABLE BORDER=0 WIDTH=570 CELLSPACING=0 CELLPADDING=0>
<FORM name=matchForm action=''>
<TR>
<TD class=mbr><span class=sbb>Välj match: </span>
<SELECT name=matchVal onChange='document.matchForm.submit();' height=15 valign=bottom>
<OPTION value=1,105785:3911 SELECTED>1. W Bromwich - Manchester U</OPTION>
<OPTION value=2,105777:3911>2. Arsenal - Charlton</OPTION>
<OPTION value=3,105779:3911>3. Blackburn - Middlesbrough</OPTION>
<OPTION value=4,105786:3911>4. West Ham - Portsmouth</OPTION>
<OPTION value=5,105780:3911>5. Bolton - Sunderland</OPTION>
<OPTION value=6,105783:3911>6. Manchester C - Wigan</OPTION>
<OPTION value=7,106941:3911>7. Reading - Wolverhampton</OPTION>
<OPTION value=8,106938:3911>8. Norwich - Sheffield U</OPTION>
<OPTION value=9,106933:3911>9. Coventry - Leeds</OPTION>
<OPTION value=10,106934:3911>10. Crystal P - Ipswich</OPTION>
<OPTION value=11,106942:3911>11. Sheffield W - Preston</OPTION>
<OPTION value=12,106936:3911>12. Luton - Derby</OPTION>
<OPTION value=13,106944:3911>13. Stoke - Burnley</OPTION>
</SELECT>
<input type=hidden name=pageID value=>
<input type=hidden name=product value=1>
England, Premier League
</TD>
</TR>
</FORM>
</TABLE>
</TD>
</TR>
</TABLE>
<TABLE WIDTH=570 CELLPADDING=0 BORDER=0 CELLSPACING=0>
<TR>
<TD COLSPAN=2><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=6></TD>
</TR>
<TR>
<TD CLASS='sbr'><B>Matchstart:</B> Lör 18/3 16:00</TD>
<TD CLASS='sbr'><B>TV-sändning:</B>  Canal+ Lör 18/3 15:55</TD>
</TR>
<TR>
<TD COLSPAN=2><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=6></TD>
</TR>
<TR BGCOLOR='#cc0000'>
<TD COLSPAN=2><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=6></TD>
</TR>
<TR BGCOLOR=#cc0000>
<TD CLASS=mwb COLSPAN=2 VALIGN=center><IMG SRC='/img/spacer.gif' WIDTH=6 HEIGHT=6>Matchfakta</TD>
</TR>
<TR BGCOLOR='#cc0000'>
<TD COLSPAN=2><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=6></TD>
</TR>
<TR>
<TD COLSPAN=2><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=5></TD>
</TR>
<TR>
<TD COLSPAN=2>
<TABLE BORDER=1 BORDERCOLOR='#ABABAB' WIDTH=570 CELLSPACING=0 CELLPADDING=2>
<TR BGCOLOR='#ABABAB'>
<TD CLASS=mbb WIDTH=176><IMG SRC='/img/spacer.gif' WIDTH=6 HEIGHT=6>W Bromwich</TD>
<TD CLASS=mbb WIDTH=218><IMG SRC='/img/spacer.gif' WIDTH=6 HEIGHT=6>Senaste mötena:</TD>
<TD CLASS=mbb WIDTH=176 ALIGN=right>Manchester U<IMG SRC='/img/spacer.gif' WIDTH=6 HEIGHT=6></TD>
</TR>
<TR>
<TD CLASS=sgr VALIGN=top><B>Hemmastatistik:</B><BR>6 1 8    20 - 19</TD>
<TD CLASS=sgr ROWSPAN=3 VALIGN=top>051226   Manch.U-West Brom   3-0<BR>051130   Manch.U-West Brom   3-1<BR>050507   Manch.U-West Brom   1-1<BR>041127   West Brom-Manch.U   0-3<BR>031203   West Brom-Manch.U   2-0<BR>030111   West Brom-Manch.U   1-3<BR>020817   Manch.U-West Brom   1-0</TD>
<TD CLASS=sgr ALIGN=right VALIGN=top><B>Bortastatistik:</B><BR>9 3 3    29 - 20</TD>
</TR>
<TR>
<TD CLASS=sgr VALIGN=top><B>Senaste matcherna:</B><BR>060311  1-1 Birmingh. (B)<BR>060304  1-2 Chelsea (H)<BR>060226  0-2 Middlesbr (H)<BR>060211  1-6 Fulham (B)<BR>060204  2-0 Blackburn (H)<BR></TD>
<TD CLASS=sgr VALIGN=top><B>Senaste matcherna:</B><BR>060312   2-0 Newcastle (H)<BR>060306   2-1 Wigan (B)<BR>060226   4-0 Wigan (H)<BR>060218   0-1 Liverpool (B)<BR>060211   3-1 Portsmo. (B)<BR></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<br>
<TABLE WIDTH=570 CELLPADDING=0 BORDER=0 CELLSPACING=0>
<TR BGCOLOR='#cc0000'>
<TD><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=6></TD>
</TR>
<TR BGCOLOR=#cc0000>
<TD CLASS=mwb VALIGN=center><IMG SRC='/img/spacer.gif' WIDTH=6 HEIGHT=6>Serietabell</TD>
</TR>
<TR BGCOLOR='#cc0000'>
<TD><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=6></TD>
</TR>
<TR>
<TD><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=5></TD>
</TR>
<TR>
<TD> <TABLE WIDTH=570 CELLSPACING=0 CELLPADDING=2 BORDER=0>
<TR BGCOLOR=#ABABAB><TD CLASS=mbb ALIGN=center>Lag</TD>
<TD COLSPAN=6 CLASS=mbb ALIGN=center>Hemma</TD>
<TD COLSPAN=6 CLASS=mbb ALIGN=center>Borta</TD>
<TD COLSPAN=8 CLASS=mbb ALIGN=center>Totalt</TD>
</TR>
<TR bgcolor='#F2F2F2'>
<TD CLASS=mbr nowrap WIDTH='20%'>1. <FONT color=#000000>Chelsea</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>14 </TD>
<TD CLASS=mbr ALIGN='right'>1 </TD>
<TD CLASS=mbr ALIGN='right'>0  </TD>
<TD CLASS=mbr ALIGN='right'>35</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>8   </TD>
<TD CLASS=mbr ALIGN='right'>10 </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>2  </TD>
<TD CLASS=mbr ALIGN='right'>23</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>10   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>24 </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>2  </TD>
<TD CLASS=mbr ALIGN='right'>58</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>18  </TD>
<TD CLASS=mbr ALIGN='right'>75</TD>
</TR>
<TR bgcolor='#FFFFFF'>
<TD CLASS=mbr nowrap WIDTH='20%'>2. <FONT color=#cc0000>Manchester U</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>9 </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>1  </TD>
<TD CLASS=mbr ALIGN='right'>27</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>8   </TD>
<TD CLASS=mbr ALIGN='right'>9 </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>3  </TD>
<TD CLASS=mbr ALIGN='right'>29</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>20   </TD>
<TD CLASS=mbr ALIGN='right'>28 </TD>
<TD CLASS=mbr ALIGN='right'>18 </TD>
<TD CLASS=mbr ALIGN='right'>6 </TD>
<TD CLASS=mbr ALIGN='right'>4  </TD>
<TD CLASS=mbr ALIGN='right'>56</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>28  </TD>
<TD CLASS=mbr ALIGN='right'>60</TD>
</TR>
<TR bgcolor='#F2F2F2'>
<TD CLASS=mbr nowrap WIDTH='20%'>3. <FONT color=#000000>Liverpool</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>11 </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>1  </TD>
<TD CLASS=mbr ALIGN='right'>20</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>5   </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>5  </TD>
<TD CLASS=mbr ALIGN='right'>14</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>14   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>16 </TD>
<TD CLASS=mbr ALIGN='right'>7 </TD>
<TD CLASS=mbr ALIGN='right'>6  </TD>
<TD CLASS=mbr ALIGN='right'>34</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>19  </TD>
<TD CLASS=mbr ALIGN='right'>55</TD>
</TR>
<TR bgcolor='#FFFFFF'>
<TD CLASS=mbr nowrap WIDTH='20%'>4. <FONT color=#000000>Tottenham</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>9 </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>1  </TD>
<TD CLASS=mbr ALIGN='right'>25</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>12   </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>5  </TD>
<TD CLASS=mbr ALIGN='right'>16</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>16   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>13 </TD>
<TD CLASS=mbr ALIGN='right'>10 </TD>
<TD CLASS=mbr ALIGN='right'>6  </TD>
<TD CLASS=mbr ALIGN='right'>41</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>28  </TD>
<TD CLASS=mbr ALIGN='right'>49</TD>
</TR>
<TR bgcolor='#F2F2F2'>
<TD CLASS=mbr nowrap WIDTH='20%'>5. <FONT color=#000000>Arsenal</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>10 </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>2  </TD>
<TD CLASS=mbr ALIGN='right'>32</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>9   </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>8  </TD>
<TD CLASS=mbr ALIGN='right'>13</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>14   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>14 </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>10  </TD>
<TD CLASS=mbr ALIGN='right'>45</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>23  </TD>
<TD CLASS=mbr ALIGN='right'>47</TD>
</TR>
<TR bgcolor='#FFFFFF'>
<TD CLASS=mbr nowrap WIDTH='20%'>6. <FONT color=#000000>Blackburn</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>10 </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>2  </TD>
<TD CLASS=mbr ALIGN='right'>24</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>13   </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>9  </TD>
<TD CLASS=mbr ALIGN='right'>14</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>21   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>14 </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>11  </TD>
<TD CLASS=mbr ALIGN='right'>38</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>34  </TD>
<TD CLASS=mbr ALIGN='right'>46</TD>
</TR>
<TR bgcolor='#F2F2F2'>
<TD CLASS=mbr nowrap WIDTH='20%'>7. <FONT color=#000000>Bolton</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>8 </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>1  </TD>
<TD CLASS=mbr ALIGN='right'>20</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>7   </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>5  </TD>
<TD CLASS=mbr ALIGN='right'>17</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>21   </TD>
<TD CLASS=mbr ALIGN='right'>27 </TD>
<TD CLASS=mbr ALIGN='right'>12 </TD>
<TD CLASS=mbr ALIGN='right'>9 </TD>
<TD CLASS=mbr ALIGN='right'>6  </TD>
<TD CLASS=mbr ALIGN='right'>37</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>28  </TD>
<TD CLASS=mbr ALIGN='right'>45</TD>
</TR>
<TR bgcolor='#FFFFFF'>
<TD CLASS=mbr nowrap WIDTH='20%'>8. <FONT color=#000000>Wigan</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>6 </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>7  </TD>
<TD CLASS=mbr ALIGN='right'>18</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>19   </TD>
<TD CLASS=mbr ALIGN='right'>7 </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>5  </TD>
<TD CLASS=mbr ALIGN='right'>16</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>17   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>13 </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>12  </TD>
<TD CLASS=mbr ALIGN='right'>34</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>36  </TD>
<TD CLASS=mbr ALIGN='right'>43</TD>
</TR>
<TR bgcolor='#F2F2F2'>
<TD CLASS=mbr nowrap WIDTH='20%'>9. <FONT color=#000000>West Ham</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>7 </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>5  </TD>
<TD CLASS=mbr ALIGN='right'>24</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>18   </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>5  </TD>
<TD CLASS=mbr ALIGN='right'>18</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>22   </TD>
<TD CLASS=mbr ALIGN='right'>28 </TD>
<TD CLASS=mbr ALIGN='right'>12 </TD>
<TD CLASS=mbr ALIGN='right'>6 </TD>
<TD CLASS=mbr ALIGN='right'>10  </TD>
<TD CLASS=mbr ALIGN='right'>42</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>40  </TD>
<TD CLASS=mbr ALIGN='right'>42</TD>
</TR>
<TR bgcolor='#FFFFFF'>
<TD CLASS=mbr nowrap WIDTH='20%'>10. <FONT color=#000000>Manchester C</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>9 </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>4  </TD>
<TD CLASS=mbr ALIGN='right'>24</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>13   </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>9  </TD>
<TD CLASS=mbr ALIGN='right'>15</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>21   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>12 </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>13  </TD>
<TD CLASS=mbr ALIGN='right'>39</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>34  </TD>
<TD CLASS=mbr ALIGN='right'>40</TD>
</TR>
<TR bgcolor='#F2F2F2'>
<TD CLASS=mbr nowrap WIDTH='20%'>11. <FONT color=#000000>Everton</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>7 </TD>
<TD CLASS=mbr ALIGN='right'>1 </TD>
<TD CLASS=mbr ALIGN='right'>6  </TD>
<TD CLASS=mbr ALIGN='right'>14</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>16   </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>7  </TD>
<TD CLASS=mbr ALIGN='right'>10</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>21   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>12 </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>13  </TD>
<TD CLASS=mbr ALIGN='right'>24</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>37  </TD>
<TD CLASS=mbr ALIGN='right'>40</TD>
</TR>
<TR bgcolor='#FFFFFF'>
<TD CLASS=mbr nowrap WIDTH='20%'>12. <FONT color=#000000>Newcastle</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>7 </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>2  </TD>
<TD CLASS=mbr ALIGN='right'>17</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>10   </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>1 </TD>
<TD CLASS=mbr ALIGN='right'>10  </TD>
<TD CLASS=mbr ALIGN='right'>12</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>22   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>11 </TD>
<TD CLASS=mbr ALIGN='right'>6 </TD>
<TD CLASS=mbr ALIGN='right'>12  </TD>
<TD CLASS=mbr ALIGN='right'>29</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>32  </TD>
<TD CLASS=mbr ALIGN='right'>39</TD>
</TR>
<TR bgcolor='#F2F2F2'>
<TD CLASS=mbr nowrap WIDTH='20%'>13. <FONT color=#000000>Charlton</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>6 </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>6  </TD>
<TD CLASS=mbr ALIGN='right'>17</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>17   </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>6  </TD>
<TD CLASS=mbr ALIGN='right'>17</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>21   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>11 </TD>
<TD CLASS=mbr ALIGN='right'>6 </TD>
<TD CLASS=mbr ALIGN='right'>12  </TD>
<TD CLASS=mbr ALIGN='right'>34</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>38  </TD>
<TD CLASS=mbr ALIGN='right'>39</TD>
</TR>
<TR bgcolor='#FFFFFF'>
<TD CLASS=mbr nowrap WIDTH='20%'>14. <FONT color=#000000>Aston Villa</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>6  </TD>
<TD CLASS=mbr ALIGN='right'>15</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>17   </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>6 </TD>
<TD CLASS=mbr ALIGN='right'>5  </TD>
<TD CLASS=mbr ALIGN='right'>18</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>20   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>8 </TD>
<TD CLASS=mbr ALIGN='right'>10 </TD>
<TD CLASS=mbr ALIGN='right'>11  </TD>
<TD CLASS=mbr ALIGN='right'>33</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>37  </TD>
<TD CLASS=mbr ALIGN='right'>34</TD>
</TR>
<TR bgcolor='#F2F2F2'>
<TD CLASS=mbr nowrap WIDTH='20%'>15. <FONT color=#000000>Middlesbroug</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>5  </TD>
<TD CLASS=mbr ALIGN='right'>21</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>24   </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>7  </TD>
<TD CLASS=mbr ALIGN='right'>16</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>22   </TD>
<TD CLASS=mbr ALIGN='right'>28 </TD>
<TD CLASS=mbr ALIGN='right'>9 </TD>
<TD CLASS=mbr ALIGN='right'>7 </TD>
<TD CLASS=mbr ALIGN='right'>12  </TD>
<TD CLASS=mbr ALIGN='right'>37</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>46  </TD>
<TD CLASS=mbr ALIGN='right'>34</TD>
</TR>
<TR bgcolor='#FFFFFF'>
<TD CLASS=mbr nowrap WIDTH='20%'>16. <FONT color=#000000>Fulham</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>9 </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>3  </TD>
<TD CLASS=mbr ALIGN='right'>25</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>17   </TD>
<TD CLASS=mbr ALIGN='right'>0 </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>12  </TD>
<TD CLASS=mbr ALIGN='right'>13</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>29   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>9 </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>15  </TD>
<TD CLASS=mbr ALIGN='right'>38</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>46  </TD>
<TD CLASS=mbr ALIGN='right'>32</TD>
</TR>
<TR bgcolor='#F2F2F2'>
<TD CLASS=mbr nowrap WIDTH='20%'>17. <FONT color=#cc0000>W Bromwich</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>6 </TD>
<TD CLASS=mbr ALIGN='right'>1 </TD>
<TD CLASS=mbr ALIGN='right'>8  </TD>
<TD CLASS=mbr ALIGN='right'>20</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>19   </TD>
<TD CLASS=mbr ALIGN='right'>1 </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>8  </TD>
<TD CLASS=mbr ALIGN='right'>6</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>24   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>7 </TD>
<TD CLASS=mbr ALIGN='right'>6 </TD>
<TD CLASS=mbr ALIGN='right'>16  </TD>
<TD CLASS=mbr ALIGN='right'>26</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>43  </TD>
<TD CLASS=mbr ALIGN='right'>27</TD>
</TR>
<TR><TD COLSPAN=21 bgcolor='#ffffff' align='center'><IMG SRC=/img/heldraget.gif height=2 width=560></TD></TR>
<TR bgcolor='#FFFFFF'>
<TD CLASS=mbr nowrap WIDTH='20%'>18. <FONT color=#000000>Birmingham</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>7  </TD>
<TD CLASS=mbr ALIGN='right'>16</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>17   </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>9  </TD>
<TD CLASS=mbr ALIGN='right'>7</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>22   </TD>
<TD CLASS=mbr ALIGN='right'>28 </TD>
<TD CLASS=mbr ALIGN='right'>6 </TD>
<TD CLASS=mbr ALIGN='right'>6 </TD>
<TD CLASS=mbr ALIGN='right'>16  </TD>
<TD CLASS=mbr ALIGN='right'>23</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>39  </TD>
<TD CLASS=mbr ALIGN='right'>24</TD>
</TR>
<TR bgcolor='#F2F2F2'>
<TD CLASS=mbr nowrap WIDTH='20%'>19. <FONT color=#000000>Portsmouth</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>3 </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>6  </TD>
<TD CLASS=mbr ALIGN='right'>10</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>17   </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>1 </TD>
<TD CLASS=mbr ALIGN='right'>12  </TD>
<TD CLASS=mbr ALIGN='right'>10</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>32   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>5 </TD>
<TD CLASS=mbr ALIGN='right'>6 </TD>
<TD CLASS=mbr ALIGN='right'>18  </TD>
<TD CLASS=mbr ALIGN='right'>20</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>49  </TD>
<TD CLASS=mbr ALIGN='right'>21</TD>
</TR>
<TR bgcolor='#FFFFFF'>
<TD CLASS=mbr nowrap WIDTH='20%'>20. <FONT color=#000000>Sunderland</FONT> </TD>
<TD CLASS=mbr ALIGN='right'>0 </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>11  </TD>
<TD CLASS=mbr ALIGN='right'>9</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>28   </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>0 </TD>
<TD CLASS=mbr ALIGN='right'>12  </TD>
<TD CLASS=mbr ALIGN='right'>10</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>24   </TD>
<TD CLASS=mbr ALIGN='right'>29 </TD>
<TD CLASS=mbr ALIGN='right'>2 </TD>
<TD CLASS=mbr ALIGN='right'>4 </TD>
<TD CLASS=mbr ALIGN='right'>23  </TD>
<TD CLASS=mbr ALIGN='right'>19</TD>
<TD CLASS=mbr ALIGN='center'>-</TD>
<TD CLASS=mbr ALIGN='left'>52  </TD>
<TD CLASS=mbr ALIGN='right'>10</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<br>
<link type='text/css' rel='stylesheet' href='/includes/svsstyles.css'><TABLE width=570 border=0 cellpadding=0 cellspacing=0>
<TR>
<TD>
<TABLE WIDTH=570 border=0 cellpadding=0 cellspacing=0>
<TR BGCOLOR='#cc0000'><TD><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=6></TD></TR>
<TR BGCOLOR='#cc0000'><TD CLASS=mwb VALIGN=center><IMG SRC='/img/spacer.gif' WIDTH=6 HEIGHT=6>Matchanalys och experttips</TD></TR>
<TR BGCOLOR='#cc0000'><TD><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=6></TD></TR>
</TABLE>
</TD>
</TR>
<TR>
<TD><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=2></TD>
</TR>
<TR>
<TD CLASS=mbr><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=6></TD>
</TR>
<TR BGCOLOR='#ababab'>
<TD CLASS=mbr><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=2></TD>
</TR>
<TR BGCOLOR='#ababab'>
<TD CLASS=mbr>
<IMG SRC='/img/spacer.gif' WIDTH=5 HEIGHT=6><span class=mbb>Experttippare: </span>Ralf Edström</SPAN>
</TD>
</TR>
<TR BGCOLOR='#ababab'>
<TD CLASS=mbr><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=2></TD>
</TR>
<TR>
<TD CLASS=mbr><IMG SRC='/img/spacer.gif' WIDTH=570 HEIGHT=2></TD>
</TR>
<TR>
<TD>
<TABLE WIDTH=570 BORDER=0 CELLSPACING=0 CELLPADDING=0>
<TR>
<TD CLASS=mbb>Ralfs tips : </TD>
<TD ROWSPAN=4><IMG SRC='/img/expertcomment/raffe.gif' ALT='Ralf Edström' BORDER=0></TD
</TR>
<TR><TD><IMG SRC='/img/spacer.gif' WIDTH=10 HEIGHT=2></TD></TR> <TR><TD class=sgb rowspan=2>Experttipskommentaren ännu ej inlagd</TD></TR> </TABLE>
</TD>
</TR>
<TR><TD colSpan=2><IMG height=6 src='/img/spacer.gif' width=570></TD></TR><TR><TD COLSPAN=2><IMG SRC='/img/bdivider.gif' WIDTH=570 HEIGHT=10 BORDER=0></TD></TR><TR><TD colSpan=2><IMG height=6 src='/img/spacer.gif' width=570></TD></TR><TR><TD COLSPAN=2><TABLE CELLPADDING=1 BORDER=1 BORDERCOLOR='#ffffff' CELLSPACING=0 width=370><TR BGCOLOR='#ababab'><TD CLASS=mbb WIDTH='100'> Andra tips:</TD><TD CLASS=mbb ALIGN='center' WIDTH='90'>1</TD><TD CLASS=mbb ALIGN='center' WIDTH='90'>X</TD><TD CLASS=mbb ALIGN='center' WIDTH='90'>2</TD></TR><TR><TD CLASS=sbb>Svenska folket:</TD><TD CLASS=sbb ALIGN='center'>43%</TD><TD CLASS=sbb ALIGN='center'>21%</TD><TD CLASS=sbb ALIGN='center'>36%</TD></TR><TR><TD CLASS=sbb>Tio tidningar:</TD><TD CLASS=sbb ALIGN='center'>0</TD><TD CLASS=sbb ALIGN='center'>0</TD><TD CLASS=sbb ALIGN='center'>10</TD></TR><TR><TD CLASS=sbb>Oddset:</TD><TD CLASS=sbb ALIGN='center'>-</TD><TD CLASS=sbb ALIGN='center'>-</TD><TD CLASS=sbb ALIGN='center'>-</TD></TR></TABLE></TD></TR><TR><TD COLSPAN=2><IMG SRC='/img/bdivider.gif' WIDTH=570 HEIGHT=10 BORDER=0></TD></TR></TABLE>
</code>

/Tyronne

Svara

Sv:Hämta data från websida och spara i en access databas?

Postades av 2006-03-16 12:41:26 - Greger Gustavsson

Har lyckats hämta sidan på två olika sätt!

Hur gör man på ett enkelt sätt för att fliterar ut datan?

:-) /Greger

nedan kod c#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Net;
using System.Text.RegularExpressions;
using System.IO;

namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)
{
WebClient webClient = new WebClient();
const string strUrl = "http://www.svenskaspel.se/pl.aspx?PageID=159&menuid=0&parentid=4248";
byte[] reqHTML;
reqHTML = webClient.DownloadData(strUrl);
UTF8Encoding objUTF8 = new UTF8Encoding();
textBox1.Text = objUTF8.GetString(reqHTML);
string myString = objUTF8.GetString(reqHTML);

StreamWriter sw = new StreamWriter(("1x2.txt"));
sw.Write(myString);
sw.Close();
}

private void button2_Click(object sender, EventArgs e)
{
//Retrieve URL from user input box

string strURL = "http://www.svenskaspel.se//includes/visualElements/matchfacts.aspx?product=1&match=115141&matchval=1&omg=3901";

String strResult;
WebResponse objResponse;
WebRequest objRequest = System.Net.HttpWebRequest.Create(strURL);
objResponse = objRequest.GetResponse();
// the using keyword will automatically dispose the object
// once complete
using (StreamReader sr =
new StreamReader(objResponse.GetResponseStream()))
{
strResult = sr.ReadToEnd();
// Close and clean up the StreamRead
sr.Close();
}

textBox1.Text = strResult ;

}

private void button3_Click(object sender, EventArgs e)
{

}

}
}

Svara

Hämta data från websida och spara i en access databas?

Sv: Hämta data från websida och spara i en access databas?

Sv:Hämta data från websida och spara i en access databas?

Nyligen

Sidor

Statistik

Kontakta oss