I'm building an app to manipulate information in a CSV (tab-delimited) file. The 1st part is to load the file and I'm having a real tough time of it. I'm using MS Visual Basic 2010 Express. Here's the code I have with a few comments:
[Code]...
I am a beginner learning Visual Basic and am creating a simple quiz.I need my program to load the quiz questions and answers from a CSV file that I have created and saved in the resources folder.
I need some code to load the CSV file into VB and then populate a 2D array with the values from the table.
i want to save and load an array as and xml file. what is the easiers way to do so.
View 2 RepliesI have a Customer File, and want to serach through the customer file to find a customer. I want to be able to Load the data into an array, and then from that array into the list view. BUT i don't want all of the feilds. I only want 3 (out of a total of 7), CUST ID, FNAME, Lname, etc. When the user clicks on the searched Customer, it then displays that customer in the form.
What I am not sure about doing is loading the file into an array
Edit: The file is a .dat file. I will happily attached my form if someone requires it
EDIT2: Can't count to 7
when i try to load i get this error:
An unhandled exception of type 'System.NullReferenceException' occurred in Jeopardy.exe
Additional information: Object reference not set to an instance of an object.
on this line:
VB.NET
question(0, 0) = node.Attributes("Question1").Value
note that i did declare:
VB.NET
Dim question(,), answer(,) As String
Here is my code to save:
VB.NET
Dim filepath As String
Dim results As DialogResult
results = SaveFileDialog1.ShowDialog
[Code]...
firstly this is not exactly a problem but more like a quiz. I have 3 arrays which I will load data into from a dataset, in the future this set of data might expand and the code will get excessively long, how can I load the data as seen below using loops without using additional array?
[Code]...
why my code doesn't work? I want the array elements to be loaded into a listbox when the button is clicked. Is it because not all elements in my array have been filled? I've tried putting the array declaration as a global variable and as a local one (below), but the same error occurs as soon as the button is clicked - "ArgumentNullException was unhandled".
Private Sub btnLoadCustomerNames_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadCustomerNames.Click
'String array holds maximum 100 customer names
[Code].....
I found this code on the net that allows you to put the contents of an array into a datagridview:[code]This works fine as is, but can someone tell me how I can add items to the array without them all being contained in a single statement?How would I modify or seperate this out to use it inside of a loop?[code]
View 7 RepliesOkay, so I have been developing my own MP3 player recently, and now I thought I would make the player remember what songs were in the playlist when it shut down. It now remembers the playlist file that was used last, but I would still rather make it so that it remembers all the songs without saving the playlist.
I've been using a setting to save the playlist file, but when I try this:
...it doesn't work. The savedSongs is a System.Collections.ListArray. Heres the code at Form_Load I'm using at the moment.
Dim loadSongs As New System.Collections.ArrayList
loadSongs = ExperimentalPlayer.My.Settings.savedSongs
lbl_songname.Text = ""
[Code].....
Should I use some other kind of variable to save the filepaths? Well, the other option is that I use a text file for that, but I'd rather make it like this.
What would be the best way to load and save a multi-dimensional array (of bytes). I've looked through streamreader tutorials but it always seems to instructions on how to save strings. I also know there's a very easy way to save a one-dimensional array, but it doesn't work on multi-dimensional ones. What should I be reading up on?
View 5 RepliesI have a huge assignment tommorow in which i have to make a trivia game on visual basic. In this game you have to be able to make your own questions (modify/delete etc). Basically I have one form where you can add questions into one listbox and answers into another listbox. Now i have another form with the actual game board. I want to load each individual listbox item from the other form into the array on the game board form. Example. the first item of form2.listbox1 into question(1)
I got this so far
Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim i As Integer
[Code]....
The assignment called for a VB.Net (not web based) program that would accept user input for the loan amount, interest rate, and term of loan, and display the monthly payment of the loan then list the loan balance and interest paid over the term of the loan. the list will be longer than the screen so use loops to display a partial list, hesitate, and then display more of the list. So, I did exactly that and the program works fine. However, after submitting this program for grading, The instructor for the class tells me, "One thing you should work on is not using a timer to pause.
You should not use a scroll bar either." He says I should work on loading the results into an array or use a loop with a counter that can be used to display a given number of results with a more results button for displaying more (but without a scroll bar?). Like I said, this program works fine and I am not asking anyone for any specific code (some sort of example would be great but not necessary) What I am asking for is an explanation of how I would go about loading results into an array to be used for displaying just partial results at a time in some way other than I used here: [Code]
I have made a function which opens a random image, but sometimes I get the 'Index out of bounds of array' error.
VB
Private Sub OpenRandomImage() Handles mnuOpenRandom.Click
If FolderBrowserDialog.ShowDialog <> vbOK Then Exit Sub
Dim Path As String = FolderBrowserDialog.SelectedPath
Dim BmpFiles, GifFiles, JpegFiles, JpgFiles, PngFiles As Array
BmpFiles = IO.Directory.GetFiles(Path & "", "*.bmp")
[Code] .....
I'm creating a small program to read from an SQL server, loading result into an array, pivoting the array to my liking and mailing it out to selected members of a group. It's going to be run once a day with Windows schedule. I have the connection, query and mail sorted, but not the datareader to array bit.
(line 26)?
Imports System.Data
Imports System.Data.SqlClient
Imports System.Net.Mail
[CODE]...
I want to be able to able to read the dimensions of a TIF image without loading the entire file.
PS Using Visual Basic 2008 on Vista64.
I don't know whether it is simple or not because i am new to programming. my requirement is : In my vb.net winform application, the filenames of the files present in "D:Project" willbe displayed in DataGridView1 control. Now I want to load these files one after another into memory stream buffer and add the headers("ID","Name","Class") to the content in the file. Then I want to save these files in "C:" with "_de" as suufix to the filename i.e.,sample_de.csv.
View 1 RepliesOk here we go again, im a complete beginner to coding and have started with visual studio 2008 using the .net/vb libraries, as my first project i went with an emulation application, and it went great:So now i think its time to move onto a little more advanced tech's, so i added in a combo box and i want to change how my code works, and this is where my troubles are.To start of with the combo box, i have it added to my winform and have 3 items on it 'Action' 'RPG' and 'Sim' and i have made 3 .txt files in the projects root folder with the same names. What i want to have happen is when the user selects for instance 'RPG' from the combo box the items displayed in the listbox change to the contents of the rpg.txt file. After searching around for a few hours and no luck i tried this
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
If (ComboBox1.SelectedItem = "RPG") Then
[code].....
I have a project that I am doing which is as follows and need your help to complete the last section I can start word no problem with process.start("winword.exe")the problem is the attachment I attached the documents using project resources and then add exisiting text files and attach it to the project but when I debug I get the following error the code used is as follows
Process.Start(My.Resources.Results
I am using the following code and I get an error that the file isn't residing where in REALITY IT IS! I know its my syntax.BTW, this directory structure I also created in the Solution Manager.
Me.rtbReader.LoadFile(Application.StartupPath & "BooksKJVNT Matthew.rtf")
When I get ready to load the .txt into the listbox, it says that there is an error, yet I have no compiler errors. Here is my assignment I am having trouble with:
Public Class Form1
'Define the Members Structure
Structure Members
[Code].....
I am trying to create a program which reads data from a text file and insert the data in to a SQL 2005 table, but unfortunately it only reads the first line and insert correctly but not the rest of the lines on the text file
The text file looks like this
Test.txt
John, Doe, 40, 12/04/1968
Micke, Gulm, 39, 07/08/1970
[Code].....
sort out this issue as I need read the entire text file which in reality will be about 5000-10000 lines and insert them in to the SQL DB line by line.
Is it possible to load an *.ico file onto a PictureBox ? I know I can use : PictureBox1.Image = System.Drawing.Image.FromFile("C:MyImage.jpg") but I'd like to use an icon . I have tried some other methods that read "Icon" , but I failed . Up to now the only thing I have thought is converting the file format form *.ico to *.jpg , but I think that's ridiculous ...
View 11 RepliesI have an xml file called "QuotesxmlDoc", in my program I have written code for a search screen that searches the xml file for titles or keywords in quotes saved and the information is then shown in a datagridview, see the code below:
Private Sub btnSearchQoutes_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearchQoutes.Click
Dim xmlnav As XPathNavigator
[Code].....
On the main screen of the program, I want to show all the saved quotes from the xml file in a datagridview, I just need to show the date, category, author, title of the quotes, I also need the datagridview to refresh everytime a new quote is saved.
I've written the following sub to load a comma delimited file into my datagrid view but it's hanging up when it attempts to load the first two values into the cells of the datagridview. I think it's having trouble adding the cells to the datagrid. I have tried writting them directly using the .text of the specific row and cell but when I incremented to the next row it hung up because the row didn't exist (I think).
[Code]...
one I'm trying to load a INI file to a combobox then into a Listview but I'm returning with an empty variable. I have a INI file containing the following format:
[Code]...
I have an application that reads data values (numeric) from a data file. Due to a change in data requirements, I need to put these into a paramArray so I can calculate the MEDIAN of the series of numbers. I have seen some of the MSDN examples and they are all good except they load the paramArray with ArrayName(#, #, #, #, #). That's OK for a simple example, but how do I load a paramArray while reading numeric data from an ASCII input file? The number (Ubound) of samples is usually 153 but can vary considerably.
I think I can work out the rest of the MEDIAN calculation from the MSDN example code.
how to make thise: Form3 to have 1 .swf file that will apear when the program starts after the .swf fineshes to show Form1 ?
View 1 RepliesI'm trying to load the contents of text files into a listbox. It loads the file fine but adds an extra character at the end. I have a feeling it has something to do with my Split command but I'm not sure how to fix it.
Here is what I have:
Dim ofd As New OpenFileDialog
ofd.Filter = "Text files (*.txt)|*.txt"
Dim result As DialogResult = ofd.ShowDialog
[Code]....
I have been searching for days to get some code that will do this. I need to open a spreadsheet and read maybe 2 dozen cells into variables in a VB.Net program. Specifics are: MS Office 2003, Vis Basic of VB.Net 2008. Everything seems to revolve around the following lines which do not work for me. I am not sure if this is version differences as most ppl here do not name which version they are using. [code]Does this method not work in VB.NET 2008?
View 2 RepliesI generate my xml into "variable string str" by using "dataset.GetXml" and then I write the "xml which is contained in variable str" into "file.xml" by using sFile.WriteLine(str) while 'sFile' is a stream reader"My reason for using 'writeline' instead of 'dataset.WriteXml' because I need to encrypt the 'xml stored in 'str' before I store it into file.xml.I got everything fine for the encrypted result, and so does the decrypted result as well.Here's the decrypted result of my file.xml below (I have checked it the xml value which in str before encryption and which in decrypted file.xml. They are all match well)Here is my plain xml value before it got encrypted or decrypted which I stored it in variable str by using GetXml. I don't know for sure but my xml value doesn't contain declaration "<?xml version="1.0" encoding="utf-8" standalone="yes" ?>" like common xml used to have.All the xml file which I got from GetXml is just like below (No declaration like <?xml version="1.0" encoding="utf-8" bla ?>) Book 1 2010-09-22T14:43:00.0000000+07:00
And since I think it may not cause any problem then I keep coding and decrypt it which is going well and the decrypted result is perfectly same ofcourse.My problem is, when I try to make my xml value show in Data GridView by using the code below, and run the debug, it prompt an error said "could not find the file c:laFile.xml ".
ds = New DataSet
path = System.IO.Path.GetFullPath(strFileToDecrypt)
ds.ReadXml(path)
[code].....