I've never used XML before so you will have to forgive me. I'm trying to pull attributes from this XML file. Specificly the SourceType ID:
HTML
<?xml version="1.0" encoding="utf-8"?>
<main>
<SourceType ID="XAML">
[Code].....
I also got as far as creating an XPath Query: (/main/SourceType/@ID) but for the life of me do not know what to do with it. Im trying to pull all source type ID's into an array of strings if it is possible!
Private Function currentv(ByVal version As String) As String
Dim filePath As String
filePath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) & ".minecraftin"
[Code]....
im trying to pull from the file located at: filepath & "rpgversion.txt"
and display it in the textbox2
as "0.5.3" for example
text which is located inside the .txt file rpgversion.txt
I'm trying to pull data from a PDF to run calculations.What would be the best way to approach this?
View 7 RepliesI have a textbox where a user enters the time in minutes:seconds format. I want to take whatever number that is in front of the colon and store it in a variable called minutes, and whatever is after the colon and store it in a variable called seconds. I have everything declared and my code written, I just don't know how to take the text from a textbox and when the value is stored in my variable to only include up to the colon. I think it has to do something with the string remove method, and I can remove the colon, but I don't know how to get the characters after it. (and I can't use number of characters because I don't know how many the user will enter)
View 1 RepliesI've been having some trouble being able to pull the text from the monthly balance column and displaying in the textbox (remainbalancebox) beneath it, all I can make it do is display the text in the bottom left column, when all i really want displayed is the last text on the RIGHT column?
View 3 RepliesI want to pull selected data from an Excel spreadsheet.I can populate a datagrid, but want to narrow the data down.
Try
Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim DtSet As System.Data.DataSet
[code].....
here'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 currently have an unlimited amount of columns and rows in a DataGrid. Pendinginformation from a user I would like to display every row from the datagrid into a checkedListBox but I only want to show specific columns depending on their column Names. Currently my code will display every row. My problem is getting only the selected columns depending on the name of their header.
The code that I have currently is:
For Each row As DataGridViewRow In CSVInput.DataGrid1.Rows
If Not row.IsNewRow Then
[code]....
I'm trying to learn a little about pulling information from other applications and finding it pretty difficult to find what it is I need to do. Let me give you an example of what I'm trying to do and perhaps someone can point me in the direction I need to work in.
I want to read Ventrilo from my VB application, specifically I want to know when someone is talking in the channel I am in. That is my end goal. I can pull the handle using FindWindow
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" _
(ByVal lpClassName As String, _
ByVal lpWindowName As String) As Long
[code]....
I know this is pretty simple but Im a little stuck. I need to take items from a listbox and print however many items are in that listbox to a receipt. So far I have
For i = 0 To lstselectedtoppings.items.count - 1
lblreceipt.text = lstselectedtoppings.items(i)
Next i
I know this is pretty close to what I need , what am I missing though?
Basically we're creating a multiform app for class with 3 different forms. its going to be a game.
My startup form asks only for your name and your total units to play with. Then you're able to click a play button, which opens up a new form that will display your total units available (from the first form) and allow you to enter how much you wish to wager for that round.
I wish to know how to pull the info from my textbox (txtUnits) on the first form (frmWelcome) and have it show up in a label(lblCurrentGameStake) on my second form (frmMain).I thought about maybe putting the value in a string and then calling that on my second form but it doesn't work. Private Sub btnPlay_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPlay.Click
strStake = txtUnits.Text
[Code]...
I am pulling urls into excel, but excel formats the data. if a website displays 000.4500 excel formats it to .45.... i need everything exactly like displayed on the webpage, so excel should not do anything with it.
I tried formatting the worksheet to text (keep everything as entered exactly) and that did not solve the problem.
I can show code, but i'm not sure if this is a coding problem at all. I am just confused and can't seem to find any good information on this problem.
how to pull information from Access and display it on a form with many different txtBoxes. For example I have 2 Queires written as well as the "Fill,GetData" for the tableAdapter. I just can't figure out how to say txtBox1 you use Query1 and txtBox2 use Query2. I'm getting data in my text boxes just not that information I need to be there so I have it bound properly as well as pulling from the right column of the data base. I'm using VB.Net 2005 and a Access 2000 Database if that helps/matters
View 8 RepliesIm just pulling information from SQL and populating textboxes etc.My question is firstly i have an issue because i can figure out how to do it, and secondly is there an easier way of writing this.So my Issue, i wrote a function to connect to SQL and pull information back which is fine it fills DS(Dataset) and then i want to be able to assign the relevant information within the DS to the desired textboxes,
[Code]...
So what's happening is that I click the Edit button, type the updated values and hit Update. But the code-behind gets the original values not the updated values. I can't figure out why. It's always worked before.
Markup
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False"
CellPadding="7" ForeColor="#333333" GridLines="None" Font-Size="Small"
ShowFooter="True" DataKeyNames="CapID">
[code]....
Im trying to pull 2 bits of information form the access db.
My db sting is:
Shared Function GetLastPost(ByVal forum As String) As String
Dim MyResult As String
Dim con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:Documents and SettingsperkinjMy DocumentsVisual Studio 2010WebSites
[code]....
but i want to get 4 bits of info from my db
Auther
lasttime
ID
numrep
and im not sure how to display this within my page_load
I am using a stored procedure to fill a dataset with a large amount of data (47k rows and 8 columns). I am needing to fill two tables with the results of this stored proc.One table will have data representing 47k reps that currently have credit for a transaction. The other table will be a mirror copy of the 1st table with 47k reps that were supposed to get credit for a transaction. This application is going to take credit from one rep. and give the credit to the other rep record in the 2 mirrored datasets. It's taking 30 seconds for the data adapter fill method to return records to my application. I would like to reduce the amount of time it takes for this request to process.
Here's the contents of the stored proc:
Code:
ALTER PROCEDURE [spGetSalesCode]
@Period varchar(15)
[code]....
how I can better return a relatively large dataset to vb.net more quickly?
How can I pull a word out of text and use it? I want to create a hyperlink and use the urls in the text. So for example if I have text that says: John clicked on the link and went to vbcity.com. How can I make the [URL] a url?
View 8 Repliesdatabase name = DataTable
Pulling data from Access database in .net?
I need to build an application (vb.net or c# or a web application) that pulls financial stocks closing price
for that day.For example:
Input: DELL, IBM, INTC
Output will be a table with the closing prices (pps) of the stocks for that day.Im not sure where to start as far as to find a source that provides that information in a format so that I can extract and place it in Excel (or plain test file). Meaning where do I get the feed?
It's been about... er, how many years since vB5 came out? Since I wrote my most recent project, so I'm struggling to remember things and get used to the new VB2010 environment.
I am trying to figure out the best way to go about pulling information out of a table.
Top row: Mileage of a vehicle
Left column: Year of a vehicle
The data it would then spit back out is the maximum term a bank will finance a vehicle based on year and mileage.
What would be the best way to pull that data? I'm thinking the easiest way to maintain the data is with an excel spreadsheet that is called by the VB app to pull the data, but I've never had to pull data in this format before.
How 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.
First 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 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 RepliesThis 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 having a problem iterating through a BindingSource and pulling out each unique entry. I can't take credit for this code, as it was privided to me by jmcilhinney. My initial code was much more lengthy involving For..Next loops and such. There was a post about this earlier, but it got buried before it was resolved, hence the Part 2...
Dim platforms As New List(Of String)
Dim platform As String
For Each drv As DataRowView In bsGames
[code]....
Now, bsGames is a BindingSource, Platform is a column in that source, which does contain entries, as I am using their values in various labels on the form. What the code aims to do is iterate through the Platform column of the BindingSource, check to see if it is already in the platforms List and if not, add it there. When the loop is finished, it then binds the List to a dropdown combobox (cbbCategoryFilter). I am developing on VB 2005, .NET Framework 2.0. I was informed of another way to do this using LINQ by none other than the great jmcilhinney, and I mean that, not a suckup , but it requires .NET 3.5, which is unsupported in 2005. I'm remiss to use 2008 Express over my 2005 Pro, though, so I'm trying to get this to work.
I have even set up breakpoints and added the platform and platforms variables to the watch and even after executing this code, they remain empty, which baffles me as it seems it SHOULD work. I've read through the code several times and can see the logic of it plain as day. The program is going to be a glorified cataloger, which will store all sorts of data in several categories, such as games, movies, music, etc... This particular code is aimed to pull the distinct platforms from the Games table and put them into a dropdown so they can be filtered. I could just hardcode the Platforms into the dropdown, but I find it much more intuitive to find which ones actually exist in the BS, then just list those. You can see the benefits of this. Once this code is finished and working, I plan to filter the ListBoxs BindingSource with the text from the dropdown.
P.S. By the way, no errors whatsoever, just no results either. Dropdown remains empty, variables never change like they should.
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 need to copy the text from a webpage into a txt file which will then be copied into a txtbox on my form (this parts done),the web page url will always be the same and the page will contain just a line of text that will chage from time to time
also i need it not to update the text file if the page displays "page cannot be displayed"i think the best way to do this is if i always start the website text and end the text with a certain "very random" word like "websitedownload" this will never come up anywhere elsealso if it doesnt copy unless the url is exactthis will stop default search engines kicking in.the website is mine/company's so this i can do