This is my Connection String :
cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" & PathtoTextFile & ";" + "Extended Properties=""text;HDR=YES;FMT=Delimited""")
[code].....
I have it set up so that the person hosting an event only has to copy the standardized form from a competitior's post on the forum. The basic format is as follows:
Quote:
Name
ISNAME
Gender
[Code]....
allHorses is a global 2D array for holding each horse as they're added to the roster. Right now I'm trying to get it to add the information for just one horse; once I get it worked out I'll make it dynamic and what not.
I'm having this exception while trying to get the value of a cell from a table.[code]...
View 2 RepliesI'm reading a binary file. Apparently its older, and some of its values are based not on position, but on null terminated bytes. Position 17 thru 35 represents a value, however, if their is a null byte at 30, then you get garbage if you try to read 17 thru 35 as a value...
I need to read, specifically, from 17 to 29 in this instance because pos 30 is a null byte.
Have to read it byte by byte, no problem. Not sure though the syntax of comparing a null byte specifically.
If you need a sample of the binary file, I can post it.
I'm Alan and I'm writing a little program (beginner), but I'm stuck and I can't get any further. So I hope one of you guys can help me solve following problem.Let me explain what I'm making, so it can give you all a better perspective.
For a this project I'm receiving data via the RS232 communication port. So basically I receive bytes. These bytes are converted to a string. So for example I receive this:"BAA" this is good because I can get the correct decimal value for "B"(66) and "A"(65) using the command asc("A") in .NET.but sometimes I receive a character that exceeds the 0-127 limit for example ""(128) (please see [URL]..But now when I try to get the decimal value of "" I get 63 instead of 128. I searched the Internet and forums for an answer but I didn't find one that fits my problem.
So if it's possible, can one of you code experts explain me how to fix this problem ? It would help me a lot. I hope I described my problem clearly, but if there are some questions,
i am not getting the integer values in dataset while reading from an excel files the field which is integer will be showing as NULL.
View 1 RepliesSo I want my program to read a file, but sadly there are null characters in the text file. The program searches for strings and I want it, when searching, to ignore all of the null values and just the actual characters. Is this possible?
View 4 RepliesReading Excel in .NET - some columns are read in as null
View 10 RepliesI have a vb.net app that I can read a .xls file into a dataset or loop through as oledbdatareader and it gives the same result.Some of the rows have all nulls when I loop through them but if I open the same file in Microsoft Excel I can see that row fine.[code]From the info above the first two SKU values would come through fine but when I get to the 3rd row it would show a null.Is it possible that it kind of inherits the first rows type and since the 3rd row isn't all numeric if nulls it? [code]
View 1 RepliesThe end of the text document my application is reading is denoted by a character that I cant identify, copy or paste. I attached an image of it so you can see. I have no control over the formatting of the document so I can't change the character. During debugging it shows the same character as shown in the picture, but if I hit the little tack next to where the variable shows then it changes to "f". However, if I try to see if the variable equals "f" it returns false.
View 3 RepliesI am having a problem writing a string like a word "Zürich" the output became "Z�rich"
I am using StreamReader and StreamWriter.
Code: below
Imports System
Imports System.IO
Imports System.Text
Module Module1
[CODE]...
I must search a binary string for a pattern. This worked fine in VB6 using Get to read a file into a string and using InStr to search for the pattern. The conversion from VB6 to VB.NET changed Get to FileGet and warned of new behavior, but I don't see anything in the FileGet documentation about not being able to read 0 value bytes.
I don't mind at all changing to a new method, but ultimately I must get the data into a string rather than an array.
[Code]...
How do I write an expression to calculate all characters of each row by my own defined value to each character = all the A and B and C and etc. will be as 2 and all I and J and whatever ... will be 1 so I need an end result of the total.
View 3 RepliesI am working on a sub that essentially needs to open a text file, and replace all instances of a certain character with a unicode character. I'm trying to do this by reading the original text file byte by byte, converting it to a character, and then either adding that character to a memory stream or writing the unicode character to the memory stream. Then I'm saving the memory stream to the original file.
[Code]...
[Code]...
For each character of this string I want a new character out of the string and then remove the character from the list of characters that still maybe used for other characters. It may not get the same character, you could basically just call this encryption, but it's not what I am making. I don't want to waste my time doing this one hour while VB can do this for me in <1 second.
I am writing a hangman type game and I am displaying the word to the user in a label as all *'s, but I cannot figure out how to have just one of the *'s changed in the label to the correct letter when the user inputs the correct letter into the text box and clicks the check letter button.Everything else in the program works perfectly, except for this part.[code]When I use the .Replace it changes all of the *'s to the correct selected letter.
View 2 Repliesthe coding is to 'Get input string and put its character into List, and replace the character with other.'but having problem putting each character into List and also replacing it,[code]
View 2 RepliesI want to read a text file(.txt) character by character into a database.There are 28 characters on each line and I want to read the first 16 into a column in a database and the rest in another column in the database.
View 7 RepliesIn my VB.NET application I compare words that are recorded using IPA, many of which have many diacritic marks. In one of the comparisons, I compare the words character by character. But when I iterate over the characters, the diacritic marks come out as separate characters (as I would expect since this is unicode)However, a u character is different than a u plus an accent for the purposes of this program and needs to be distinguished.
View 1 RepliesI have a fairly simple piece of code:
Private _PurchaseDelivery as PurchaseDelivery
Protected Overrides Sub InsertItem(ByVal index As Integer, ByVal item As PurchaseDeliveryItem)
[Code]....
Which is inside a class which overrides a custom list base. The code is occassionaly throwing an unhandled exception, System.NullReferenceException, on this line when used in production:
If _PurchaseDelivery IsNot Nothing AndAlso _PurchaseDelivery.DefaultSKUBinID.HasValue Then
DeafultSKUBinID is declared as an Integer? (Nullable Int) in the PurchaseDelivery class. I cannot see what might be causing this error, why would this be returning an error?
I have a value I am pulling into a string that looks like this:
M'arta
I need to have it to translate the numeric value into an actual value so that the string looks like this:
M'arta
how to accomplish this in VB.NET? Here is the relevant line of code that returns this result:
Dim occupant as String = GridView1.Rows(e.RowIndex).Cells(2).Text
My form has a texbox where user enters an ID. IDmust be4 chracters in length andof the form: begins with either "E" or "e" and the next 3 chracters cannot be "all characters".
Example:
E102 - corect
e3ff - correct
[code].....
I want to read a text file(.txt) character by character into a database.There are 28 characters on each line and I want to read the first 16 into a column in a database and the rest in another column in the database.
View 17 RepliesI am trying to error check a piece of code
This is from my previous thread which 'Codeoder' help me on..
[URL]
I have a RTB which I import with a set of 7 or 9 didit numbers, 7 for Staff and 9 for Students. e.g. Staff numbers
0628189
0628191
0629991
[Code].....
I've been working with the substring command and after coding up all the things I needed it to do, I saw a post on here where the "For Each" statement was used basically to do the same thing.Lets say we just want to take a string apart one character at a time and add each character to a label. Which would be more efficient?I made a cheap example to show ...
Code:
ABinary = "0110 1100 0001 1011"
For x = 0 To Len(ABinary) - 1
[code].....
How to check whether a column is null i use the following code but I got this error "Input string was not in a correct format."
[Code]....
When I put a break point to the last if clause in the sub ("If (backOrder < 0) Then", see below) it runs until the break point, if I put the break point further below, I get the following error:
Cannot insert the value NULL into column 'OrderID', table 'WHM.dbo.OrderDetails'; column does not allow nulls. INSERT fails. The statement has been terminated.
I've discovered first hand that it only happens when prodqty is bigger then qtyOnStock, thus executing the if clause.
The code:
Private Sub NCOSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NCOSubmit.Click
Dim sqlText As String = ""
[Code]....
I'm able to convert a character to its corresponding Character/ASCII code using "Asc(CHAR)". I can't find anything on converting this returned Integer back to its original Char form.
View 3 RepliesI have MIDNAME column in my table. I want to remove all the character starting from the second character going to the right and after removing it, a period "." will be added right after the letter which left. How do I it?
View 6 RepliesI am trying to create a treeview in VB.net, the data has to be loaded from MSAccess 2010 database. When I try to run this program I get error : Argument Null Exception was unhandled, 'column' argument cannot be null and the program crashes. I have pasted the code as under:
Imports System.Data.OleDb
Public Class frmRating
Private Sub frmRating_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles
[code].....
