I am having issues with the program I am doing. I am supposed to store the style number and prices in a sequential access file which I have done. And the user is supposed to be able to click on a style number in the list box and then display the price from the style number in the pricelabel. When I click my display button
[Code]...
I want to read a csv file into an access database , here is my code :
Private Sub load_csv()
Dim ConnectionString As String
ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
[Code].....
The strange thing is that the file really is there, so what else could go wrong ?
So I've been using VS2010 and haven't had too many problems transitioning over but I have an issue at the moment and I can't seem to find the answer...I have been using a little piece of code to insert comma delimited files to a database, which works great.Today, I received a Tab Delimited file from a client....obv I could edit, replace tabs with commas and move on but I want to know the right way to do this so I feel accomplished I've tried two ways so far1. This is the code I use for comma delimited with a slight change for the tabs -- PF refers to a class module that has the functions I use to get files and parse file paths
Dim Conn as New ADODB.RecordSet
PF.InputFile = PF.GetFile("Select LMR Demo File", "")
conn.Execute("SELECT * INTO [tmp_lmr] FROM [Text;Database=" & PF.InitLoc &
[code].....
I am currently working on a vb project. What I am trying to do is reading a XML file and saving all the data in to the Access DB. Once this is done, I read the data from the access Db and display it in the required fields in VB form. Issue is, when i store the value in the access, a weird character is assigned before and after the data. The character is a square box with question mark in it. Also the same character displays on the VB form as well
[Code]...
I'm trying to build an app that will read custom properties set in an accdb file. Basically, I'm trying to build a Front End updater (Yes I know there are others already built, but they don't work the way I want). The Custom properties are initially set manually by pressing the Office button, going to Manage, then Database Properties and selecting the Custom tab.
I've got most of the code set up, but my sticking point is how to read the custom properties.
Following is the function I use within Access VBA to get the properties, but obviously this is not going to work in VB.Net.
[Code].....
I think I need to replace one or more of the 4 lines after the On Error (yes I know I need to change the Error trapping too). I'm guessing I need to connect to the database file (an accdb, btw) and then go from there to define the container and documents collections.
I'm having trouble reading a file into a filestream from a CD. I get 'Access to the path denied'. Works fine when reading a text file from a local drive, but getting error from CD. Dim fs As New IO.FileStream(filename, IO.FileMode.Open)
View 12 RepliesI am trying to select Multiple files and then read the file 1 by 1, i want to know how to specify the file number in Visual Basic .net 2008
Here is a sample code which i have used in reading the text file.
With dlgOpen
.Filter = "txt Files (*.txt)|*.txt"
.Title = "Open Text Files"
[Code]....
Actually my text file is a dump file and i need to make a program to process this dump file. I may ask some stupid questions but this is just a beginning, i want to parse INDIVIDUAL text file line by line. In the above code i have used the ReadToEnd function in order to display it in TextBox but i may use ReadLine Function or Read function to read line by line or characters respectively.
I have attached an Access Database with the predefined tables in it, I want to update the contents in Access Database. Supposingly if my textfile contains Names (Sam,Julie,Joseph,Marina), how will i update my attached Access table in vertical order !
We have a site that is public facing, let's say it's [URL]. When the SSL is implemented, [URL], I can no longer access the jQuery 1.4.3 file on my own server. Furthermore, after a tweak to the security setting, I was able to get past the 'Access is Denied' error, but the first call was null. I understand there is a problem with different protocols actually being within the scope of the cross-domain problem? Is that true? And if so, will this now require JSONP?
<script type="text/javascript" src="<%= ResolveUrl("~/js/jquery-1.4.2.min.js") %>"></script>
<script type="text/javascript" src="<%= ResolveUrl("~/js/jquery.jstree.min.js") %>"></script>
<script type="text/javascript" src="<%= ResolveUrl("~/js/jquery.dataTables.min.js") %>"></script>
<script type="text/javascript" src="<%= ResolveUrl("~/js/jquery.cookie.min.js") %>"></script>
how to proceed. One of our customers is going to be sending me a flat file (ASCII-Text) that I have to break down and scan. Every line ends in a CrLf - So I know I can use StreamReader and ReadLine(). I did get it to work on one of the test files they sent.(A very Short file) However, the file is not delimited at all and every field is padded to the full length they specified. Here's the format of the file:
[Code]....
what I have to do is read the 5 names inside the Sequential Access File and store them in an array. I'v encountered a problems in storing it in an array. Here's the code
Dim infile As IO.StreamReader
Dim names(4) As String
Dim filename As String = "names.txt"
[Code]....
Theres an error in the code saying that a string cannot be converted into a one dimensional array.
I am working on a project in VB 2008 and need it to do this:Read first line from text file (using Openfile)Enter line into textbox on formDo some other codeThen Read second linefrom text fileEnter line into same text boxand loop until we have gone through text fileI am not sure how to read line by line from text file then enter it in textbox. I can open the Openfile and get the filename and everything, but I just am not sure how to read from it or enter that line into the textbox.Here is what I have, its not much but its a start:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim FileReader As StreamReader
[code]....
i have to store and read pdf files in an access db. it seems not to work with larger files
the code for reding fom db:
[code]
Dim cn As New OleDbConnection(constr)
Dim cmd As New OleDbCommand("SELECT ....., cn)
cn.Open()
[Code]....
I need to write data to a file, preferably in binary format, but I am unaccustomed with the concept. Where's the easiest place to get the basics? I could come here with a specific need, but I'm at the point right now where I am more willing to work within the confines of keeping it simple.
Here's what I know:
1. how to open a new file
2. how to specify the record length
3. how to close the file
Some specific questions:
Does the record length have to be constant throughout the file?
Can I read the nth record without reading the whole file?
I want to be able to get the table structure / design / column information from an access database. I have created a post in the Database/Access section with no luck, here, but I am wondering if I could achieve this through vb (2008 express edition) rather than the access sql query itself. My overall goal is to compare one DB structure with another, an integrity check if you will.
View 5 RepliesI have a program using the OleDbCommand to read an indexed Access database. [code]I notice that when step debugging the program, the file is not being read in correct order.Example: it will read the record with "B" in the D01 field before a record with "A" in the same field.The record with "B" is the second record in the database.I do note that all records in the database are read before exiting the loop, just not in any apparent order.
View 5 RepliesIm experiencing some problems while attempting to read a connection string from an App.config file in my Data Access Layer.I added the App.Config to the DAL Class Library, and added my connection string to the connectionStrings section but when I try to read it from my DAL its Returing Nothing.
[Code]...
I'm reading data from a .mdb access database to a form in my app. However the text is sometimes becoming scrambled as shown belowDatabase:Quote:The resistance of a 2.5mmonductor of length 8m and resistivity p = 1.72
View 6 RepliesI 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 have a database in access and one of the fields is 'Is Quick'. I have a query that filters all of these out. How would I get the data from that query in Visual Studio 2010 (Express). VB code please.
View 1 RepliesI would like to be able to read a column of numbers from an Access database into a VB.NET program and then manipulate that data.For example I have a column of numbers and want to add them up and then take the averageThe maths is not a problem but how do I read the column of data into the program. I know how to do this if I first export the Access data into a CSV file, but
View 11 RepliesI have conquered the problem of the database however what i need is the serial port data sent to a database and outputted on screen however i keep getting cross thread errors ..
Imports System.Data.OleDb
Imports System
Imports System.ComponentModel
Imports System.Threading
[code]....
I want to perform two hashing operations concurrently on a single file, without reading the file twice. Is there some way to share the FileStream between two synchronized hashing threads? For example:
Dim Stream As New IO.FileStream("...", IO.FileMode.Open)
Dim HashA, HashB As Byte()
Dim A = New System.Threading.Thread(Sub()
[code]....
Maybe some way of caching a stream? Trouble is, I don't want the entire file in memory at once (it could be many gigabytes in size) and I don't want the file read more than once, due to speed issues. I want the file cached only sufficiently to ensure that both threads can work.For example, suppose at some point in time, thread A had read 100k of the file, but thread B had only read 20k of the file. The portion of the file between 20k and 100k should be cached; but then progressively forgotten as thread B catches up. Then again, if thread B is too slow, we might still end up with hundreds of megabytes being cached.Maybe thread A should be made to wait while thread B catches up. Maybe the ReadByte() function of the stream should block for a while if one of the threads is too far behind?
I have a checked list box that is populated with the text from a text file. I started off with this code:
Dim FileToLoad As String
FileToLoad = TextBox3.Text
Dim fs As FileStream = New FileStream(FileToLoad, FileMode.Open)
[code].....
friend of mine has no HTML knowledge so I'm attempting to write a program that replaces certain parts of a html file to suit his needs.I've edited the HTML file and marked certain parts with "tags" like this:
#IMAGEURL1# I have a textbox where he can copy + paste an image URL and hopefully the #IMAGEURL1# is replaced with the contents of the textbox.
So can someone please enlighten me to-as how to open a HTML file (there's no textbox to display the contents just yet, I'll add one if needed), find the specified text and then replace it with whats in a textbox.
I am trying to import a TAB (NOt comma) delimited text file into a DataGridView. The following code works fine if I have a comma separated file. All I have to do is change the FMT to "Delimited".It just does not work with FMT=TabDelimited. All columns are read into single datatable column. The text file is ANSI text and I have double checked to make sure Tabs are tabs and not spaces, even exported a sample Tab Delimited file from Excel.Can this even be done using Text Driver? [code]
View 2 RepliesHow do I play a WAV file while the computer is reading aloud a text file? It uses Text to Speech synthesis and I need a laughter wav to play when the computer comes across something funny in the line.
View 2 RepliesI'm new to Visual Basic. I'm trying to get this code to read a .txt file line by line. If the only thing that the line says is "B" it should add one to the intTotalBoys integer and so on with G for Girls, F for Fathers, and M for Mothers. I'm not sure why it won't work. [code]
View 4 RepliesI would like to read from file, and ignore lines that start with --. I know how to read line by line but i just need to ignore those lines.
View 3 RepliesSo I need to write out an object to a text file as well as read in objects from text files.How do I accomplish this? This is the code i've used to read and write just simple lines of text. Is there a small modification to this or just a different function i use to read in an entire object?
Code:
Dim path As String
path = "Security.txt"
[code].....
I have just recently been using VB 2010 after using VB5. I have noticed a lot of changes. The problem I have is that I wish to open and save text files to and from arrays in the background. I've attached what I would do in VB5. I have searched around, but all the examples I find use a Textbox instead of an array. Can anyone show me how I can do this with VB 2010?
View 1 Replies