I am trying to pull wind direction, temperature and speed, data from this webpage, I have had not much success with it at all, I think that I have the correct method but get stuck on the HTML coding. the webpage is: [URL] I sort of know how to get to the HTML code, but get lost on how to define the ellements that are required. I have a screen capture of where I get up to.
View 1 RepliesHow would i go about pulling text from a web page using webbrowser 1 and having it update in a timer displaying the viewer count in a label.
<strong class="first" id="channel_viewer_count">1</strong>
I Can make it recognize id="channel_viewer_count" but it's not showing the viewer count in the label.
I would like to search a webpage for a value in the left column of a table, then pull the value from the right column as my result. In a Visual Basic Forms Application.
the data is listed in a table, for example...
abc 123
def 234
ghi 345
jkl 456
and if i just want the value of ghi ( I know "ghi", but i want the goal of the code to find the "345")
I have a PHP Page that displays airport information in a list in the following order
[code...]
Using that delimited method of ";" then a break, how can i put all of those into a combo box. There are a few hundred.
I've code this code below:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim hwrRequest As HttpWebRequest = HttpWebRequest.Create("http://www.example.com/web-service.php")
[Code]....
The MsgBox() at the end shows the response, which as I've added to my script, echos the result from the $user and $pass variables which are supposed to retrieve those details being written to the stream above, but they show up empty.
I'm retrieving those values by doing: $user = $_POST["user"]; $pass = $_POST["pass"];
I'm trying to pull data from a PDF to run calculations.What would be the best way to approach this?
View 7 Replieshere's what I'm doing. I'm putting together a program that will allow employees that work under me to all submit shift reports in the same format instead of getting multiple different formatted text files.
I have a list box that they add "actions" they've performed throughout the day. It's populated by a combo box and some text boxes.I've got it all functioning minus one aspect...
[Code]...
Here's my problem... it's only outputting the FIRST set of items. The "Upgraded" accounts all list but the "Downgraded" and "Canceled" are not there.In a perfect world, I wouldn't ever need to worry about "Canceled" or "Downgraded" but... the world isn't perfect so,
I have a table in my SQL DB that contains :- ID- Date From- Date ToI then have a SQL function that pulls out the Start Date (See code below)
View 1 RepliesI wanted to create an event that when I hit a button, it will check if the webbrowser has reached THISPAGE.html.
If webbrower1.Url.toString = "thispage.html" then 'this line may have been webbrowser.Url.toString("thispage.html") cant remember I tried both ways neither worked.
do something
End If
But I get a null exception error.
My other question is , is it possible to pull data or text from a website like through the webbrowser control thing and place it inside a textbox or label or something like that?
database name = DataTable
Pulling data from Access database in .net?
auto filling data into webpages. I need to write a server side application mostly a console host app that makes some queries to the SQL Server database and gets a list of lets say students and their grades.There is a third party website that gets updated at the moment some peoples working and filling that data manually.
I need to write a program that will basically open that webpage, login if required, navigate to certain page, click on certain tab, fill the data and hit the submit button. I don't think this part is that hard but the trouble comes with a client side dialog box. At the moment there is a client side dialogbox that shows up when you hit the submit button confirming the action and I need to press OK on that automatically.
I am allowed to write a windows application if not a console application and also use the web browser control to load the webpage rather than opening and interacting with the browser. If this makes it easier than so be it.
This is in ASP.net iwth VB.I have a quiz project that I've been assigned for work.This quiz project contains two main SQL Databases it pulls the info from. First is a Quiz table, which contains three columns: QuizID (Pri Key), Title, Description. This is where I declare the quizzes, indicated by the QuizID (1, 2, 3....etc)
The second table is the Questions table, containing the following columns: QuestionsID (Pri Key), Title, Answer1, Answer2, Answer3, Answer4, Answer5, CorrectAnswer, QuestionOrder, QuizID....The QuizID in the Quesitons table matches the QuizID in the Quiz table.Thus for QuizID = 1, it consists of all the questions with the matching QuizID in the Questions table. The CorrectAnswer I want to assign a simple value (1, 2, 3...etc).I need a way to take a set of questions (based on the QuizID) put them in some sort of table and randomize them (or rather shuffle them) so that each time this quiz is taken, it pulls all questions randomly, but not repeating any)...I then want the code to pull the question and coorepsonding answers to pick from in a radiobuttonlist. However, It only needs to pull the number of answers. Example, a True/False will only have Answer1 and Answer2. The other Answers will have the NULL value in it.
There needs to then be a way to go through each one of these questions that have been placed in the table (in that random order) using a "next" button. When a question and possible answwers are displayed, I alaready have code to keep the answers in the session to grade it at the end (using correctAnswer and selected answer.I have no specific way to bind the data to the Database. I have used SQLDataSource to make other connections before, but I don't know if this is the best way.
I was wondering which way would be the easiest in VS2005 to connect to and pull data from a MS SQL database. I have already setup the database connection by choosing the datasource for a DataGridView but I'm not able to retreive any information.
The steps I have taken so far:
1. Make new form
2. Drag and drop DataGridView onto the form
3. Setup the data source and respective username password
Not sure where to go from here....
I am trying to insert data into two lables from an access database(2 different tables) by doing a search. I have code that wont work
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Dim SearchPatient As String = txtNPatientID.Text
[Code].....
I just got put on a new project to design an app that will retrieve data from an excel data sheet that holds information from our VoIP server's call log. Conveniently, this call log is stored in a fixed location on the local drive that this app will be running on. After working on this for a bit, I knew right away I'm going to need someone smarter than I am...I got to the point where I can show data but heres the issue : Every time I am retrieving the date it shows it as, "08/27/2009 12:00:00 AM", how do i remove the unrelated time stamp? Here is my code in Visual Basic 2008 Express Edition:
Public Class Form1
Dim cn As System.Data.OleDb.OleDbConnection
Dim cmd As System.Data.OleDb.OleDbDataAdapter
Dim ds As New System.Data.DataSet()
[Code]...
When it is installed on a machine, it will run for all users. But for some users, it is unable to get some data from the database. I have found out that if it is run-as either administrator,or in winxp compatibility mode, it works. But if not, then some users have the problem.The database is in the same C: drive location as the exe, and it doesn't change from user to user.The computer is using windows 7 professional 32-bit.
View 4 RepliesI wanted to ask you something which is bugging me for a while. I work an IT dept at a local bank and I got instructions to make an application which should retrieve some financial info from a financial banking stats page.
The webpage can be accessed through [URL].. and the info can be seen in the web browser but I cannot extract them because the info is not available in the source code of the page.It seems it's generating the info dynamically using a jsquery.js file.
I was wondering if it's possible to make an app which uses some cache or something (I guess the the page is saved temporary somewhere on the disk for the current session) to retrieve that data in vb.net?
My program so far reads a certain webpage's source code and places it in a textbox. This much has already been accomplished.
Now I need to pick certain strings out of the rather large amount of text data and have the lines stored in variables, but the trick of it is, the exact string is unknown. The exact function should be, that the code finds certain tags from the source code, say <td> and </td> and takes the string data in between those tags, what ever it may be.
I wanna send POST data to the current web page viewed in my webbrowser. It's for logging into a page so the fields are "Username" and "Password". And then I might have to make it press the "Log in" button?
EDIT: It was easier than I thought when you don't need to do it silent in the background.
PHP
WebBrowser1.Document.GetElementById("username").SetAttribute("Value", txtPassword.Text)WebBrowser1.Document.GetElementById("password").SetAttribute("Value", txtPassword.Text)
Now I just need to figure out how to press the submit button
I am trying to pull sql data into a text file. The code works just fine, until some new data comes in from lazy employees and a couple fields (used for notes/comments) are now left blank. Originally I've never seen them blank so I didn't think anything of it.
col2 = myreader.GetString(1)
It will error if the field is ever null - I even tried using a case when:
case when note is null then '" & empty & "' else note end and set the variable emtpy = '', but vb still thinks that it's null and errors?
I generate a print preview, the only thing is, if there is enough data to fill like 2-3 pages I don't know how to generate a new page. It only fills the first page and that's it....
Private Doc As New PrintDocument()
Private Sub btnPrint_Click(sender As System.Object, e As System.EventArgs) Handles btnPrint.Click[code].....
most of the code it's just pulling data from database and printing necessary charges to the invoice, but if the invoice is more than 1 page then I don't know what to do because it only generates 1 page.
I am pulling three coloums of data from a SQL view into my data drid Day,TimeIn,TimeoutI want to colour my datagrid rows red if timeout is null and green if both the timein, timeout have data in them.[code]
View 2 RepliesFirst time actually doing anything with xml so I've been trying to follow some examples but im not getting anywhere with them, can you show me where im going wrong?First off Im pulling an xml file from the web as a string and then loading that into an xml document, heres an example of one:
HTML
<?xml version="1.0" encoding="UTF-8"?><blackoutrugby_api_response brt_timestamp="1279072295" brt_sql="2010-07-14 13:51:35" brt_iso_8601="2010-07-14T13:51:35+12:00" season="9" round="7" day="3" ><team id="44328"><id>44328</id><name>Beltra RFC</name><country_iso>IE</country_iso><region>225</region><stadium>Satory Stadium</stadium><bot>0</bot><nickname_1>The Lakers</nickname_1>
[code]....
I am building a VB.NET frontend to access an ACCDB backend built with Access 2007/2010. The backend will be on a share and accessed simultaneously by multiple users (5 max for the time being, maybe a dozen or more eventually?).My question is, what is the best way to pull the data for the fastest possible acquisition, manipulation, and updating? I'm thinking that pulling it in, then severing the connection and running all of my queries against in-memory structures would be best; am I wrong in this line of thinking?
Do the "DataRow" objects (e.g. "TicketsRow") maintain a connection to the database? I started in on building custom classes to store the data in memory which would pull from DataRows and then dispose of them, but wasn't sure if this was the best approach. My Access frontend was horrendously slow, which is part of the reason I migrated to .NET. I'm not convinced the app itself was the problem, but this solution should give me far more granular control over how the data is accessed and stored, besides the fact that VB.NET seems orders of magnitude more powerful than VBA.
i have an aspx page with vb.net back end. in that page i get names and url's from the database depending on different conditions. My requirement is that when i get the url, the code should then use that url and have that webpage in a small preview form on my existing aspx page. so basically i have a table as follows -
[Code]...
Suppose the given picture*(consider the picture as a web page)* is a web page...i have saved this web page to my HDD...now i want to parse/copy data from a specific area from the web page and store it into the database accordingly. Is this possible?? I wanna know if this thing is possible??If yes then how??
View 2 RepliesI have the following code to open a webpage:
Dim IE As Object
Dim x As Integer
Dim c As Variant
[code]....
The page that opens is in xml and in that xml there is the "page_count" that I need to pick out so I can tell my macro when to stop looping. I have dimmed it as "c" in the code above. Following is the XML.
<search>
<total_items>360</total_items>
<page_size>100</page_size>
<page_count>4</page_count>
Somehow I need c = "4", which is the "page_count". Does anyone know how I can pick out the "4" from the xml on my page?
Extract Data from Webpage?I have this code so far.[code]...
View 2 RepliesI'm looking to pull data off of a webpage that gives the data in comma delimited values.
I want to pull that data off, and I'm sure I'll have to store it in an array.
I am trying to parse a webpage and need to get the data basically the string i am looking for in a webpage looks like thisSomeone lead me in the right direction in parsing the Stuff strings?
</b></a></td><td align="left" bgcolor="#F6F6F6">Stuff1</td></b></a></td><td align="left" bgcolor="#FFFFFF">Stuff2</td></b></a></td><td align="left" bgcolor="#F6F6F6">Stuff3</td></b></a></td><td align="left"
[Code].....