I am making a quiz program, i have a datafile maker whch creates .qiz files, which hold CSVs of all questons for that quiz. the are stored as follows
***Start File***
question & "," & rightAnswer & "," & wrongAnswer1 & "," & wrongAnswer2 & "," & wrongAnswer3
question & "," & rightAnswer & "," & wrongAnswer1 & "," & wrongAnswer2 & "," & wrongAnswer3
***End File***
[Code]...
I have got an Xml like below. I want to "add" data in it. Tried alot of forums..
eg.<?xml version="1.0" encoding="us-ascii"?>
<!--Version 5.0.0.0 - 4/12/2011-->
<SalesReport>
[code].....
I was wondering if anyone has a code on how to burn data onto CD?
View 3 RepliesIm trying to extract predominately table data from a PDF file, however, I would also like the option to extract image files (such as graphs, etc) as well.Is it possible to extract data from PDF files using a VB.Net application? Im trying to get this process as automated as possible, so Im trying not to use 3rd party applications such as pdf file convertors or in-line pdf readers.
Are there any free, or relatively cheap PDF data capture API's/code snipets that I can use to import data from a PDF file? Another option is to export PDF data/images into an excel spreadsheet. Is there a .Net tool that will allow this?
basically how do i do this, i have no idea at the moment, Get a listing of all of the files in the data directory. Determine the total number of lines among only the csv files. For example, suppose the data directory contained three files:a.csv , containing 3 lines; b.csv , containing 5 lines; and c.txt , containing 7 lines. Then the total number of lines among the csv files is 8, not 15.
View 1 RepliesMy application creates, as well as, reads and writes to both xml and rtf files. A way to protect these files from tampering? That is, the content within them should only be changed by the application.
View 6 RepliesI have a routine which populates a DataGridView. I generate the data on the fly in arrays and the populate the datagridview simply by saying
For each Row in DataGridView1.Rows
DataGridView1.Rows(row.index).Cells("PastColumn) = Array(row.index)
Next
I am not saving the data to log files. I only display the results at the end of my routine. When I close the project the data is lost.I am trying to understand why one would bind data. Would you do this in the case where you are saving the data to a file and you want the datagridview to update when the file is updated or loaded again at another time?
I have developed an application using VB.NET, Visual Studio 2008 and the SQL Server database. Now I want to ignore the database (it has 1 table as customer (name,password,hour,minute)) as I don't want my client to install SQL Server separately or other overheads.I am planning to do the whole using file handling in VB.NET (manipulating the data in files itself, for example change username, password, etc.). As I am new I don't actually know the proper way and of course need assistance.
View 4 RepliesI have just completed an upgrade of a VB6 app to VB.net (2008). Everything works as it should except for one (essential) part. I cannot open more than one instance of the built app without getting a file access error. Now don't laugh but my program uses Random Access files to store the data (i know, i know the 1990's called and they want their programmer back). Anyway I've been using this method since the early 90's and it's never let me down. Until now that is. VB6 allowed any number of users to access the files but for some reason VB.net gives the following error: The process cannot access the file "C:lah blah" because it is being used by another process.
View 2 RepliesI've been tasked with writing an app that reads in various text files(.csv, .txt) in different formats with different delimiters.I then need to compare certain data in these files and report the differences.There are a couple of columns that are common between the files, but they aren't in the same place, and there is inconsistent and unnecessary header info.There is extra data(columns) in these files that I don't need.Should I parse these files into a datatable? Should I create an object for each file type to format the data and get rid of the unnecessary info?I'm not sure about the best way to tackle this problem.
View 1 RepliesI have been tasked with creating an app that will read in various text files(.csv, .txt) and compare some of the data contained within.
I thought I would read in the files and convert them to datatables. Once I had them in a datatable I figured I could remove the unnecessary rows/columns and then sort and compare the pertinent info for differences. The difficulty is that the various files are formatted differently so I will need to get each type formatted correctly. Is this the best approach?
I have read in a .csv, parsed it into a datatable, but I'm having trouble with the logic/coding to get rid of the rows and columns that I don't need. Also, I'm not sure how to handle a row that has a cell with a comma seperated list of values that will need to be split into individual rows.
I have three data files that I include with my project. They are all set to Build Action Content and Copy to Output Copy Always. I have a preferences form that allows the user to copy these files to a folder of their choosing. It works fine in the IDE. However, when deployed one file will copy but the next returns an error the the file cannot be found. In the following code block a deployed application will copy ABW11Data.sdf but cannot find 100610_40.dtb or 2118@005.dtb. They are in the deployment files and I can search and find them in the clickonce installation although they are not in the same place as the ABW11data.sdf.
If My.Application.IsNetworkDeployed = False Then
My.Computer.FileSystem.CopyFile(My.Application.Info.DirectoryPath + "ABW11Data.sdf", TextBoxFolder.Text, True)
My.Computer.FileSystem.CopyFile(My.Application.Info.DirectoryPath + "100610_40.dtb", .SelectedPath + "100610_40.dtb", True)
[code]....
i would like to encrypt my data files, which are serialized object files. is there a simple way to do this that will work trouble free on both windows xp and vista?
my environment: windows xp pro (sp3), visual studio 2008 pro, (sp1, sdk 1.1)
What I am trying to do is create a conosle app in vb.net 2008. I have a XML file (data_file.xml), and a template file (template.txt). The template file contains a few sentences, each one containing a placeholder which needs to be filled. I need to create multiple output files (.txt), which contains the contents of the template file, with the placeholders filled with the values of the placeholders in the XMl file.
The XML file is at the moment:
<?xml version="1.0" ?>
- <CATALOG>
- <group>
<placeholder1>Nigel</placeholder1>
[Code] .....
As it stands, I can create one template file, containing the filled template contents using only the first group of placeholders. I am nearly there, just trying to finish the last piece of the jigsaw.
Early on the OP was asked "how will you get the data about your music?" and it went into a whole other direction, but that's what I'm here to show: Another way to get the data about your music without dependence on the metadata.The music that I have has fairly extensive tags embedded but as I've discovered, that's not the case with all of them. It's a good starting point I suppose but is there another way? Let me jump to the end, then in the next several posts, we'll dissect the parts of it. My goal was use "only out of the components and methods" and this is what we end up with: Aside from the rudimentary things like song duration, how about if we could get a host of information about the songs, including the cover art? As shown in the example above, some also will have a link to additional information. The additional information may even contain a way to watch a music video for that song like this: Further, some will even contain what I call "Liner Notes" like this:
If this interests you, read on ...This isn't a new thought at all; I've explored this area before. Have a look at this on Code Project. Now before you go thinking that you've found the keys to the kingdom, I should explain a little minor issue about that - it doesn't work! In that, he relies heavily on three web services: Amazon Web Service MusicBrainz LyricWiki Amazon has significantly modified their service such that his methods don't work now. If you follow the posts following the thread, you'll see a few people have tried workarounds but over the years, even those stopped working because apparently they (Amazon) are in a state of flux regarding their API. LyricWiki is still alive and well, but - the music recording industry forced them to no longer offer their service to developers. MusicBrainz is in fact a heck of a resource and if you're at all interested in this topic, I would encourage you to have a look around. It's odd to work with, but it's chock full of good information and they're constantly adding to it or so it seems. All that said, this example won't use any of those but rather a different service all together: Last Dot FM. I can't say that I know much about them, but I happened onto them a few months back when I was first experimenting with all this stuff.
I'm trying to find a good strategy to access data files, image files, etc., that I want to distribute in my VB.NET deployment. The challenge I'm having is to find a place to put the files, and a means for the program to find them, regardless of whether the program is running in the Visual Studio environment as a debug build or release build, or running as an installed application.I've considered using AppDomain.CurrentDomain.BaseDirectory to find the location of the EXE file, then using relative paths to that folder. However, that approach depends on the directory hierarchy imposed by the Visual Studio tools when it separates the binaries of debug and release builds. Both builds would have to navigate upward to reach a common root folder, and the path traversal algorithm must work for the deployed EXE file too.
View 6 RepliesI am working on a program for a customer and am working in VB2010 in VB language. I have two rather large files that contain data. File #1 is over 300,000 lines of data. File #2 is over 100,000 lines. The files are CSV text files. On a User Form, there are two values, "StartTime" and "StopTime". This is the process I am doing:
1. Read both files into ArrayLists
2. Get item #1 of ArrayList #1 (we'll call this "A")
3. Get item #1 of ArrayList #2 (we'll call this "B")
[code]....
I enter the data and save, the problem I having is the data of the parentis saving but the child is not.I've notice when I click add, the parent has focus but the child does
Can I have both the parent and child data file on one form, if I can how do I get both to accept and save data.Also if anyone can suggest a bookon building and understand database for visual studio, especially about relational databases and
I have 500 odd csv files that I need to pick up and load into a table in Teradata.How do I combine this 500 files data into one file Or is there a script that will go and fetch data from each file and load it into the table.Here are more details.I have a bunch of hotels and the end of each day all the hotels dump in one file into a common folder.
Like
D:CorpHOTELSACCOUNTSREPORTINGUSA
Here I get files in the following format.
Hotels_Sales_Graph_level_20080529
Hotels_Sales_Graph_level_20080530
Hotels_Sales_Graph_level_20080601
[code].....
Now I need a script to pick all these files data and load it into one file so that I can use this file to insert data into a table using a fast load script i already have.I have a script that will read this file copy it to a new location and archive it.I can use this final file to load my table.But I dont have a script to read all these files and also read the new file that comes in everyday and load it into one csv file.
Im building a project that reads data from a text file. Its in the format of an address book:
First Name
Last Name
Phone Number
I can read thae data in to an structure:
Public
Structure AddressRcd
Public userID
[Code].....
I wish to save some data but dont want to use database. I have studies that XML files can be used for that. But I have no idea abut XML.
What is the difference between using XML and database?
the code for getting data from text files.
I have about 200 .txt files, all in same format as below.
m 998718989898
m 998766990878
F 67
P Thane
So, I want to import this in excel. I know the code for inserting the data in Excel, but no idea of getting the data from text files. This text files are actually used as contact management by the co and has contact name as file name.
providing code for getting data from a single file, Then I will run it in loop and insert in Excel.
I have a VB 6.0 application that works with random data files... Now I have to create a .Net 4.0 application that generates and update random data files.... Net Framework 4.0 can work with random data files ? Does it support again this old tecnology ?
View 1 Replieschanging data in a certain tag within an XML via vb.net.
The files will be all in subforms and look like:
<?xml version="1.0" encoding="iso-8859-1"?>
<Documents xmlns:xsi="http:www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="myxsd.xsd">
[Code].....
I get a problem with my program. My program should do :
-Explore folders from a main folder (LOGS)
-See if there are csv files
-Copy the data from CSV (all informations are on the first column)
-Paste it in one xls file (with a sheet for every csv)[code]...
This is somewhat of a multi part question, let me start off by explaining what I'm trying to do. I have an organized folder system with data files in them. Each folder has a set structure to their naming, and can contain sub folders and files. It will be a jagged directory system. I'm trying to import their structure into a TreeView. I have the workings of a recursive system that adds all files and folders into a ViewTree, however they aren't organized by parent/child.
So I get this...
-C:Temp
-C:TempData
-C:Tempfile1.txt
-C:Tempfile2.txt
-C:TempDatafile3.txt
-C:TempDatafile4.txt
etc........
How would I go about parsing the directory paths, and include them into a parent/child relationship... looking like this
+Temp
--file1.txt
--file2.txt
-+Data
---file3.txt
---file4.txt
Also I when the line item is selected, I need to know which file is selected so I can use it's full path to call up data (using an API) based upon the it's full root path.
I'm concatenating data files, but the problem is that I'm seeing some extra bytes where the files are joined. The new file has extra bytes. I had thought this was maybe a problem with encoding.Here are the methods that I've tried to use to concatenate the files. The first example I'm getting extra 0xA0 0x00 bytes.
Dim inputfiles() As String = Directory.GetFiles(sourcedir, pattern)
Dim bufSize As Integer = 1024 * 64
Dim buf As Byte() = New Byte(bufSize) {}
[code].....
My application is often used to import volumes of data. The application currently supports .CSV, .XML, and XLS. The question relates to handling EXCEL files. Specifically, what are the best practices for coding?
Today, since customers are beginning to see .XLSX files coming in, I modified the code to use either JET.OLEDB.4.0 or .ACE.OLEDB.12.0 depending on whether it was reading an .XLS or an .XLSX. My instincts tell me that cannot be the correct way to go about this. First, customers still using Office 2003 are going to have to download the AccessDatabaseEngine in order to read the .XLSX files. Second, what if a customer installs Office 2010? Are they going to have the 12.0 stuff or am I now faced with another issue.
[Code]...
I search but I didn't find the answer all of them explain how I use binary files only
View 2 RepliesI am working on a program to turn on devices at times of day and days of week. I am designing it for 15 devices and each device has a file. The problem I have is monitoring all 15 files. I can monitor each one and it works for that device, but only the device file I have called. I used data binding to create the files and can display the files one at a time, but I need to monitor the info on all 15 files actively.
View 3 Replies
