K, I'm not sure which forum this question goes in, so I am putting it here.Here's my problem.I have a customer file [CSV] I am importing to SQL. I am using JET to read it into a dataset. I am using a schema.ini file to define columns, because I have one column with up to 1000 characters in it... so I have to define it as a Memo field so it won't truncate at 255 characters.
View 7 RepliesWe have a VB.NET (aspx) website with a login first page. Once the user has logged in and is authenticated they are taken to a single page with a Menu Bar at the top and a report viewer control underneath. When the user has logged in the report viewer is initially populated by a dynamic menu (a menu of links to other reports depending on each user's permission).
Now, on some reports that the user access from the main menu, they like to export the data. The nicely formatted reports export nicely to PDF but these same reports look awful when you export to excel. Further more what is required from the excel version is no formatting and also to include extra columns of data that are available form the dataset but not from the rendered report (for use with importing these expoerts into other systems).
Is it possible to extract the data that is generated from the dataset that renders the report?What I would like to do is obtain this data and create my own excel export option (of which I will put into the page Menu bar at the top of the screen). It is important to just grab the data that is generated because different data is available depending on the parameters the user has chosen.
if a byte value can go up to 255 and two bytes are used to determine the length of packet payload data, how would I convert the two bytes to create one integer value?
State.buffer[13] = 5 and State.buffer[14] = 67
Dim PacketLengthHigh As Integer = state.buffer(13)
Dim PacketLengthLow As Integer = state.buffer(14)
[code]....
Given this Short (signed):
&Hxxxx
I want to:
Extract the most right &HxxFF as SByte (signed)Extract the left &H7Fxx as Byte (unsigned) Identify if the most left &H8xxx is positive or negative (bool result)?
This illustrates a series of bytes that I've received from a socket and assigned into a byte array (frameData). How do I extract the ascii string from frameData if FrameData.Length is 79 bytes long and I need to extract the byte locations whose begin -frameData(26) and end frameData(44) are given by the arrows I've drawn?
View 3 RepliesI am receiving ASCII data over my serial port. "51 48 46 48 48 49" for example, this represents my temperature of 30.001 degree. Now I would like to convert this ASCII numbers nad combine to readable temperature and store my data into an excel table. [Code]
View 12 RepliesCan any one tell me how I can convert an integer to a byte. I have a five digit interger and would like to have it as two bytes.
View 3 RepliesI am simply trying to get the hexadecimal value of an integer (below 255) and then place this value into a byte. I have been using the hex command, but it converts the value to a string hex value. Its been driving me mad for days now as I just cant seem to sort it!
The code is as follows:
tempIntToCompare = CInt(tempValue)
tempIntToCompare = tempIntToCompare - LowTemp
[Code]....
I want a number like 1000 (hex 3E8) to be 232, 3.
View 2 RepliesI'm using WinPcap to capture incoming data. Basically I'm dealing with a continuous stream of incoming data, either as byte array or as memorystream (pieces up to 64kb).
I need to check this data to see if there's a certain url and then extract it.
The url I need to find looks like this:http://201.122.38.5/data/today/798572987-589571?139805890582 The length of the 'code' after "/today/" is always the same. The IP address changes. What's the best/fastest/most efficient way to continuously check these byte arrays or memorystreams and extract the urls without hogging the CPU too much?
[Code]...
I want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
I'm trying to make to do a widening conversion from a byte to an integer. form has a text box for both Input, and Output, plus a conversion button. [Code] I'm trying to use a catch block, but I'm not certain how it works exactly, and also tried to use an If statement to avert the issue, but that didn't work either. When ever user inputs a number greater than what can be held within the Byte data type the program crashes from the run time error. [Code] and an error message pops up in the compiler saying overflow exception was unhandled.
View 19 RepliesI am new to vb net so please cut me some slack if this is a stupid question, I have always used vb6 before, but finding that its less and less supported so trying to learn vb.net by myself. Also I am doing this for a hobby not a profession.I am writing an Console application to read a file sequentially 1 byte at a time into a 1 byte buffer. It then copies that byte into a 4 byte lookup buffer, that moves, ie as the file pointer moves forward by one byte the 4 byte lookup buffer copies the last 3 bytes into the first 3 bytes to accept the byte at the file pointer into the 4th byte of the lookup buffer. I am doing 1 byte at a time because the data I am looking for is not at pre-determind offsets and filesizes may not be a multiple of 4.
[Code]...
Help please its driving me mad It appears as if the byte is not being transferred to the lookup buffer so that it would always be 0, either that or I am not converting it to an integer properly
I am reading/writing a fixed length header into a stream and I need to do the following in VB:
1. Convert a 2 byte integer (int16) into a byte array
2. Read 2 bytes of a byte array into an integer variable
I have a very simple question about converting a byte array into 16bit integers. I am connected to a device through a serial port. It sent me six bytes which represent three Int16 integers. For example, the byte array is called newRecievedData(5) and has a length of 6.
The manual that came with the device claims that the int Format is 8 bit MSB|8 bit LSB. Does that mean the following?
newRecievedData(0) contains 8 high bits of the first Int16
newRecievedData(1) contains 8 low bits of the first Int16
newRecievedData(2) contains 8 high bits of the second Int16
[Code]....
but VB.NET Express 2008 gives me the error that Error 1 Value of type '1-dimensional array of Byte' cannot be converted to 'Short'.
I have worked with enums for some time, but i ran in to a little problem.. So i have the Enum:
[Code]...
for example: Dim the_text_value As String = MyStuff(some_func()) ' this returns not "1", but "omg_this_is_one" how can i do this ?
I need to extract data (an integer) from the last row of a datagridview cell, add a 1 to it and use the new value to store it in a new row.
[Code]....
I have used the following code to read a memory address from a pointer and offset previously however, Now I've come to use it again and can't figure out how I got it working last time, I'm receiving the error "value of type '1-dimensional array of Byte' cannot be converted to integer" highlighting the BytesAtAddress variable in the ReadProcessMemory calls.
Public Shared Function ReadPointerFromMemory(ByVal BaseAddress As Integer, ByVal PointerOffset As Integer, ByVal BytesToRead As Integer, ByVal pHandle As IntPtr) As Integer
Dim BytesAtAddress As Byte() = New Byte(BytesToRead - 1) {}
[code]....
I need to parse a binary stream in .NET to convert a 16 byte unsigned integer. I would like to use the BinaryReader.ReadUIntXX() functions but there isn't a BinaryReader.ReadUInt128() function available. I assume I will have to roll my own function using the ReadByte function and build an array but I don't know if this is the most efficient method?
View 3 RepliesI inherited a project that includes a dialog between two applications. One in native C++ the other in VB.NET. The protocol is such that the first 4 bytes (32 bits) of the message encodes the size. However the VB.NET side never sets these first four bytes, however it does use the .net method BeginSendTo, which accepts an argument for size. Does the BeginSendTo method automatically add the size to the beginning of the message in the form of a 4 byte int?
View 1 RepliesPrivate Declare Sub Keyboard_Event Lib "user32" (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long) [Code] I know the KeyCode when i call this function. Example 13 is the keycode for "Enter". But it says that theres an error on syntax cause KeyCode is an integer not Byte. What kind of variable does it need there? I mean does it need the keycode (which is a number) or a character e.g. "a"? [Code]
View 2 RepliesAt the top of the code that follows is the method in c# into which I'm attempting to pass an integer value. Is there anyway I can change the assignment statement to the byte() PDUToSend to take care of the error I currently receive; Value of type 'Integer' cannot be converted to '1-dimensional array of Byte'.
CODE:
I am creating a class that will represent a file and I am going to have lots of properties. Now I want the properties to return either a integer or a byte array. Is this possible or do I need to create 2 different properties one for the integer and one for the byte array? When I try I get. 'Public Property something As Integer' and 'Public Property something As Byte()' cannot overload each other because they differ only by return types.
View 2 RepliesDim ScoreAddie As IntPtr = &H7FF824
Dim NewScore As Byte() = 999999
Dim p As Process
Dim myHandle As IntPtr
[code]....
Whats wrong?
I need to extract specific data from a database. With starting point in this data, I will collect information on the internet. After the information is collected I need to check if this information is already stored in the database, and if not, then add it. This action is being repeated about 500-50000 times each time the procedure is being executed. (not often)
The approach I'm taking seemes sleazy and ineffecient and I was hoping you could point out some places where I might be able to optimize it. I've two open connections at the same time. The first I use to extract data, and it stays open throughout the whole session. The second connection is being used first to check if an entry already exist and if not, to add the data.
The reason I am using two connections is due to the fact that I got a reader bound to the first one, so it is rendered unavailable.
I was thinking that maybe checking if the data existed, and adding it if not, maybe could be contracted into one command execution instead of two. I don't know if it would be possible to do this with one connection only as well, as it seemes more proper.
Operator '+' is not defined for types '1-dimensional array of Byte' and 'Byte'.How would I change the assignment statement in the code below so that each indexed byte position gets assigned the converted integer value in the for loop?
Dim byteArray As Byte()
Property Data_Out() As Integer()
Get[code].....
I need to fill a List with data from a DataColumn fetched in dataset. How can I achieve that in 1 step without looping through the entire table in dataset.I want something like this:
Dim lst as List (of Integer) = ds.Tables("Customer_Data").Columns(0)
However the above line is wrong as System.Data.DataColumn cannot be converted to System.Collections.Generic.List(Of Integer)
I'm trying to write a function that will return a dataset and an integer, is this possible?
View 1 RepliesWhy does C# define Byte+Byte=Int32 instead of Byte+Byte=Byte like VB?
View 1 RepliesI am trying to insert a small message of 150 characters into the "AdvertisingInfo" database into the "QuickPost" column. Right now there is only one row that will have various columns updated by several forms.I just started to teach myself VB10 and it has taken me 6 hours to get this far. I'm tired of trying today and am going to bed, but I need help trying to figure this out. I keep getting the error: Value of type 'Integer' cannot be converted to 'System.Data.DataSet'.[code]
View 3 Replies