Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionWebBrowser1.Navigate("http://www.finviz.com/quote.ashx?t=#symbol#".Replace("#symbol#", symbol2))
WebBrowser1.Navigate("http://www.finviz.com/quote.ashx?t=" & symbol2)
Dim nbAsset As Integer = cmdnb.ExecuteScalar For n As Integer = 0 To nbAsset - 1 Dim cmdSym As New SqlCommand("select ticker from Asset11 ", cn) Dim symbol2 As String = GetData(cmdSym).Rows(n).Item(0) WebBrowser1.Navigate("http://www.finviz.com/quote.ashx?t=" & symbol2) 'si le chargement n'est pas complet while webbrowser1.state <> 4 'on retourne la main à Windows pour détecter les clic de souris et le clavier doevents wend '*********charger la lsitbox******** ListBox1.Items.Clear() Dim htElement As HtmlElement 'extraire les données qui se trouve dans le tag td depuis le browser Dim htmlcollection As HtmlElementCollection = WebBrowser1.Document.GetElementsByTagName("td") On Error Resume Next For Each htElement In htmlcollection 'charger la listbox par les données existant dans le tag td ListBox1.Items.Add(htElement.InnerText) Next ''Remplir la BD refSite = 3 cmd = New SqlCommand("insert into fondamentals(TICKER, SOURCE_REF, LATEST_CLOSE_PRICE,[W_LOW_PRICE_52/W_HIGH_PRICE_52], EPS, MARKET_CAP, FORWARD_PE_RATIOS, PRICE_SALES,PRICE_BOOK,DIVIDEND_YIELD,DIVIDEND_RATE, Quick_Ratio, Long_Term_Debt_to_Eq, Insider_Ownership, Insider_Transactions, Institutional_Ownership, Institutional_Transactions, Gross_Margin, Profit_Margin, Previous_Close,RETURN_ON_ASSETS_ROA,RETURN_ON_EQUITY_ROE,return_on_investment_ttm) VALUES('" _ & symbol2 & "'," & refSite & ", '" & latestClosePriceT & "','" & ListBox1.Items(103) & "','" _ & ListBox1.Items(39) & "','" & ListBox1.Items(47) & "','" & ListBox1.Items(49) & "','" & ListBox1.Items(73) & "','" & ListBox1.Items(85) & "','" & ListBox1.Items(119) & "','" & ListBox1.Items(107) & "','" & ListBox1.Items(121) & "','" & ListBox1.Items(157) & "','" _ & ListBox1.Items(41) & "','" & ListBox1.Items(53) & "','" & ListBox1.Items(65) & "','" & ListBox1.Items(77) & "','" & ListBox1.Items(125) & "','" & ListBox1.Items(149) & "','" & ListBox1.Items(153) & "','" & ListBox1.Items(89) & "','" & ListBox1.Items(101) & "','" & ListBox1.Items(113) & "')", cn) cmd.ExecuteNonQuery() doevents Next