Creating A CSV Reader?
Jan 18, 2010Creating a CSV reader?
View 9 RepliesCreating a CSV reader?
View 9 RepliesI'm using the Chilkat add-on to read email from a pop3 server. I can download the headers fine but the headers all download into one column.How can I get my email to put the headers in the appropriate columns?
'Display the From email address and the subject.
ListView2.Items.Add(email.From)
ListView2.Refresh()
ListView2.Items.Add(email.EmailDate)
ListView2.Refresh()
[Code]...
What I am trying to do is to download the "From" person into the "From" columns and the "Date" of the email into the date column, so on and so forth but I'm not able to get them to go into their separate columns.
I want to launch a application called Foxit Reader pdf Reader .I know System.Diagnostics.Process.Start(path) can do it but . Requirements are Foxit Reader should be installed on machine.Now if it is installed how to serarch for the path of its Executable to provide the parameter as I can not hardcode the path for different machines.
View 3 RepliesI am having an issue with both Adobe Reader and FoxIt Reader when trying to print a PDF document. Both issues are different but a solution to either one will allow me to fix my issue.The issue I am having with Adobe Reader when trying to print using the following code is that it will not print it to the network printer I specify but just the default printer.
Dim AdobeReader As New Process
AdobeReader.StartInfo.CreateNoWindow = False
AdobeReader.StartInfo.Verb = "print"
[code].....
how would I accomplish saving a large piece of data, using the Stream Reader for the Line-by-Line, while keeping the carriage return line feeds in there?
[Code]...
I am currently rewriting a VBA XML reader to a VB.net version for a project. I have the following code in VBA:
Dim XML_Doc As Object: Set XML_Doc = CreateObject("MSXML2.DOMDocument")
Dim XML_Detail As New ADODB.Recordset: XML_Detail.ActiveConnection =
"Provider=MSDAOSP; Data Source=MSXML2.DSOControl.2.6;"
I was told that I should be able to use almost the exact code in my VB.Net version but I am running into some problems. I added as a reference to the VB.net project the Microsoft ActiveX 2.8 so I can use the ADODB.
The code in VB.Net is
Dim XmlDoc As Object : XmlDoc = CreateObject("MSXML2.DOMDocument")
Dim XmlDetail As New ADODB.Recordset : XmlDetail.ActiveConnection =
"Provider=MSDAOSP; Data Source=MSXML2.DSOControl.2.6;"
When running the application it gets to the XmlDetail and throws the following error:System.Runtime.InteropServices.COMException was unhandled. Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
I am attempting to read specific lines of GIANT text files (> 150 MB) with hundreds of thousands of lines. The files are contained on an FTP site. I can successfully open the files using FTPwebrequest and streamreader but to get to a specific line using streamreader, you have to read every line before it. Obviously this takes a lot of time when you need to get to the millionth line.
A much faster way, I think, would be to use filestream and the filestream.position function. However, I'm not sure how to open a file as a filestream from FTP. I have tried:
Dim ftpaddress as string = "ftp://####@ftp.textfile.asc+"
Dim fileStream1 As New FileStream(ftpaddress, IO.FileMode.Open, IO.FileAccess.Read)
How can i get my key's value using a stream reader [code]
View 3 RepliesCurrently i am using this code
[Code]...
I've been developing a simple virus scanner and it works by reading the hex code of a file and comparing it to signatures from a database. Anyway, the only thing slowing it down is how it reads the hex. This is the hex reading part of my code so far:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LoadFile.Click
Dim ArrayHold() As Byte
Dim Index As Integer = 0
Dim Str As New StringBuilder
[code]....
I'm looking forward to make a system using a BCode Reader. Like the way when a book has a correspond barcode and when it scan by a BCode reader the correspond info on the book will be showed in he system. So how to code the BCode reader and how it will determine the barcode of a book or what ever items that has a barcode?
View 18 RepliesHow do I really use data reader in vb.net. I'm using odbc to connect mysql and vb.net. Function I declared on a module:
Public Function form2search(ByVal drugname As String) As OdbcDataReader
cmd.CommandText = "SELECT * FROM drug WHERE Drug_name LIKE'%" & drugname & "' "
Return cmd.ExecuteReader
End Function
[Code] .....
I see a result, but it only loads the first item on the database. I've put this code in the text_changed event. What's the proper way of doing this? And what's wrong with the 2nd code, why is it only loading the first data. As you can see the con is the module where I declared the function. Then I created an object of it in the form.
Using VB 2010 on W7 x64 and I'm getting the HID device registered OK but then I never get the WM_INPUT messages. I test it on x32 Vista and same thing... no WM_INPUTs.
View 3 RepliesHow does this class look? I've spent a long time on it.
[Code]...
In an older program I am now maintaining, a SQL query is issued and the results are fed in to a DataTable and accessed through a DataTableReader.I see lots of lines like:
myInt = CInt(dtr.getvalue(42))
What I want to know is, would this ever differ from:
myInt = dtr.getint32(42)
If there could be a difference, what would trigger it?
Does anyone know of a decent OCR reader for .net?
I have some small images with text on them, i would like to use the ocr to give me the text from them..
please tell me what is below code doing? is it creating array with two values or its creating to string index which will take value later? [code]
View 4 Repliesits possible to find out in a reader how much reading is left to do. My code will be below and i think it be fairly possible during a query that would be returning data but is it possible during a query designed to give data?
Public Function queryup(ByVal queryString As String, ByVal connection As MySqlConnection)
Try
Dim newQuery As String() = Split(queryString, ":")
For Each Query In newQuery
[code]....
When I am using an OleDBConnection to read a CSV, I notice something strange When the datasource (folder) of the CSV has a number in it, it will ALWAYS skip the header record, regardless of whether HDR=Yes or HDR=No
Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + input_path + ";Extended Properties='text;IMEX=1;HDR=YES;FMT=Delimited;ImportMixedTypes=Text'")
Dim command As New OleDb.OleDbCommand("SELECT * FROM [" + input_csvFile + "]", conn)
Dim da As New OleDb.OleDbDataAdapter(command)
da.Fill(input).ToString()
I am using SQl data reader to get value from SQL database.Language VB.NET.After getting data into reader, i run a while loop
While reader.Read
If reader.HasRows() Then
/* Proessing of data *[code]....
I wanna make a time in and time out using a fingerprint device.. how can i start a coding for this in visual basic .net for attaching a device or accessing its database.
View 1 Repliesalways had a problem getting my head around it. I don't have a very strong mental model of how the code flows. My main problem is i think i understand the syntax, but not really its application. Any links people found useful would be great.
Couple of questions. The code below doesn't make sense to me (written by someone else) the application is basically a csv reader, but manipulates the data.
Public Sub entryType()
[code].....
I have not been able to print from acrobat reader.How can I do this?
View 3 RepliesAre there any examples on how to implement a datareader? I have try copying the code from MSDN but;--"Dim reader as SQLDataReader = command. ExecuteReader()"Where it is placed? As a declariton at the beggining of a form? or as as VB resource?and then how those it bind a to a dataGridView? How can I loop through each rows once is bind to use the contents of the column/row?I can perform the above function easly inside of MS Access using VBA. I have gone through various books from WROX but none of them show a clear example or the code is obsolete.
View 5 RepliesHow to know the acrobat reader is installed or not in user system,if they installed in which drive they installed? how to check this using vb.net?
View 8 RepliesI'm switching over from PHP to vb.net. And some of the concepts are a bit different. Mainly I struggle with concepts and keywords, so it hard to look stuff up. Currently I'm creating a dashboard and needs to run a lot of different sql queries. But I see where I should be able to minimize my code. But things that I have tired don't work. Example below of two chunks of code that I should be able to put in some type of loop and increment a value for my sqlstring and textbox output.
[Code]...
looking for a simple example of opening and reading in a loop a raw ascii file 1 character at a time in vb.net?
View 8 Repliesi have create a procedure to return data reader value, but it not return and returning null reference?
'Public Shared Sub GetData(ByVal Tablename As String, ByVal queryfield As String, ByVal Id As String, ByVal lblmsg As Label)
' Try
' Dim Cons As OleDb.OleDbConnection = DBHelper.GetConnection
' Dim Com As OleDb.OleDbCommand = New OleDb.OleDbCommand("Select * FROM [" & Tablename & "] WHERE [" & queryfield & "]=" & Val(Id), Cons)
[code]....
I have created an RSS Feed Reader using Visual Basic that displays a list of the news item titles in a tree view style and its link when the '+' icon is clicked. From this I have used the web browser control in visual studio to create a small web browser that will show the web page of the link that is clicked in the tree view.What I am having problems with is that i would like to create a button that will open a new web browser window and display the same link in it that is being displayed in the mini web browser on my feed reader. To do this the code I have so far is:
Private Sub expandBrowser_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles expandBrowser.Click
If expandBrowser.Tag.ToString = 0 Then
[code]....
I am trying to get a whole column from a table in sql DB. I used the code below, but in my OdbcReader, i only have 1 fieldcount.[code]....
View 4 Replies