Heres the InnerException:{"Unable to read data from the transport connection: A blocking operation was interrupted by a call to WSACancelBlockingCall."}Stack Trace:
" at MyNetworkStream.HandleOrRethrowException(Exception e) at MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count) at
[code].....
I use firebird server for 2 years and I used this code
[Code]...
I'm sending an http request through a proxy using tcp, and then using a streamreader to read the netstream...The streamreader is supposed read each line up to </html> , however it doesn't seem to be waiting for the packet/response to be fully received, as it always returns only the first 5-10 lines of HTML.If I add a breakpoint at the line "Using sr", and pause it there for a few seconds and then continue the execution, it will return the full HTML up to the </html> as it should.This is the part of my code which reads the response.
Dim sendbytes As Byte()
sendbytes = System.Text.Encoding.ASCII.GetBytes(ReqHeaders)
netstream = tcp.GetStream()
netstream.Write(sendbytes, 0, sendbytes.Length)
[code].....
I need to extract data from a .dbf file and transform it into xml. I wrote a routine that does it just fine. However now we are encountering very large .dbf files - like 2GB +. And this code throws an OutOfMemoryException on those files.
Public Function GetData() As DataTable
Dim dt As New DataTable(Name)
Dim sqlcommand As String= "Select * From MyTable"
[code].....
How can I fill Datatable with DataGridView data (VB/C# .NET)?
View 1 RepliesDim adapter As New SqlDataAdapter("SELECT price, product FROM" & txtstore.Text & "WHERE barcode='" & txtbarcode.Text & "'", con)
[Code]...
I dont the msgbox to be sure that correct string is being passed to it and it is.. But I got an error at the "adapter.fill(txtstore.text)" saying Incorrect syntax at 'barcode'.
I tried the code below but unfortunately, all i get is a combobox with U,s,e,r,s, as each line in the items collection and not the filenames of the relevant files.
the DirGetPath("Users") Function below returns my default document and application paths and appends "Users" to the end as the relevant files are stored in that Folder.
All I get is a combo box with the items as U, s,e,r,s (i.e. Users spelled out).
I tried all of the following as alternative methods too:
System.IO.Path.GetExtension()
System.IO.Path.GetFileName()
System.IO.Path.GetFileNameWithoutExtension()
[Code]....
I'm trying to read data from some local XML files and process data from them using VB.net.
The format is:
<?xml version='1.0' standalone='yes' ?>
<DataFeed>
[code].....
Ok so this is going to take some explaining. The process I am trying to do is grab data from a table function in SQL and then fill a dataset with the returned values. I then have to run this query twice more to query an alternative number table. Then add to the same table as the previous queries.This needs to be as fast as possible, so I am currently using an adapter.fill to populate the datasets and then a dataset.merge to put them all into one table.
The problem is the query can return duplicates which waste time and space, because of this I made column 3(part_ID) the primary key to stop duplicates.When this is run with the .merge it quits at the first instance of a duplication and doesn't continue with the population.
[Code]...
I am using VB.NET 2010 (Visual Basic 2010 Express) on a WPF-based project. I am also using the SQL Server Express built-in to Visual Basic 2010 express.I have just about finished refining my code for hooking up my wpf-based form to an existing SQL database (agentroster.sdf). I have a global data source (AGENT_ROSTER) connected to this database. Connections are confirmed to work properly.This is the first part of the code I'm using, irrelevant code omitted,
Dim table_adaptor As New AGENT_ROSTERTableAdaptors.AGENT_ROSTERTableAdaptor
Dim roster_table As New DataTable("roster_table")
Dim rowposition As Integer
[code]....
how do I fill roster_table with table_adaptor (or alternate method)?
i am using visual studio 2008 using vb.net. I have opened an xml stream and am reading it using xmltextreader. So far so good. I am using the following code to parse the stream and to get an understanding of what it contains and how to use the info.
[Code]...
I've got an XMLTextWriter writing to a Stream of a WebRequest. Everything works as it should:
Dim wr As WebRequest = WebRequest.Create("https://wwwcie.ups.com/ups.app/xml/ShipAccept")
With wr[code].....
How can I intercept this XML that's being written as an XMLDocument type? I tried snagging it from the stream but that gave me a 'The stream does not support reading.' exception
I am sending data to server via TCP IP Connection. I am using a continuous loop at the server end - that accepts new clients and while streams can be read, it reads data stream.
The data is sent from the client with 2 leading bytes of data that represent the size of the packet of data sent and type of data.
My question is: how do I retrieve the size of the data packet and then check that this amount of data has been retrieved?
[Code].....
I am sending data to server via TCP IP Connection. I am using a continuous loop at the server end - that accepts new clients and while streams can be read, it reads data stream.
The data is sent from the client with 2 leading bytes of data that represent the size of the packet of data sent and type of data.
My question is: how do I retrieve the size of the data packet and then check that this amount of data has been retrieved?[code]...
i need to read a large file stream binary my code is Dim sr As New IO.FileStream(srcFile,
[Code]..
I need to read signed and unsigned 8 bit, 16 bit and 32 bit values from a file stream which may be little-endian or big-endian (it happens to be a tiff file which carries the byte order indicator at the start).I initially started by writing my own functions to read the values and was able to do so for unsigned values. e.g.
Public Function ReadUInt32() As UInt32
Dim b(4) As Byte
input.Read(b, 0, 4)
[code]....
But then I started looking at signed values and my brain broke.As an alternative, I found the IO.BinaryReader which will let me read signed values directly but doesn't seem to have any way to indicate that the data is big-endian or little-endian.Is there a nice way of handling this? Failing that, can someone tell me how to convert multiple bytes into signed values (in both byte orders)?
I tried my best to shrink down the program to the following code. In this example, I have UK and USA as valid countries. If someone lives outside those countries, I wanna show an error message and highlight them on the gridview. For example, John and Chris are from China so they should be highlighted on the gridview. Either just Name or the whole row can be highlighted.
Dim dt As New DataTable
dt.Columns.Add("ID")
dt.Columns.Add("Name")
[code]....
i just got 1 question how do u create a (in excel ) variable table (database) inside a function which could be called for filling and reading through "for to next" loop module
View 2 RepliesI need to retrieve a portion of xml into a datatable
<Product>
-<productID>123</productID>
-<productName>123</productName>[code]......
Now Under product tag there are ProductID, ProductName and ProductFeatures.Under ProductFeatures tag there are three "productfeaturetext" tags.I only need to extract "Features" tag into a datatable to loop it, how this can be done ?
how i see if my cache is empty all my syntax errors are coming when i am trying to see if the cache is null and if it is to run the stored procedure
If RadioButtonList1.SelectedIndex = 0 Then
If Cache["netcache"] = null Then
bcmd.CommandText = "yearlynetsales"
[Code].....
i have a datatable with about 10000 rows and few columns (4)I have noticed that the process of reading a big table its quite slow..is there a way to improve performance in reading a datatable?
View 15 RepliesI am using/creating a DataTable so the "enforceConstrains" property is not avilable for DataTable.Error message: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Windows Form Load Event:
Private Sub Expenses_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
expensesGV.DataSource = listExpenses()
expensesGV.Columns(0).Visible = False
End Sub
My program reads a 3rd party .txt file using OleDb and reads the file into a datatable. It's overall working fine except a user will occasionally have a problem reading a file. At this point.
Line that gets hung up
Try
Dim comm1 As New OleDbCommand("SELECT * FROM " & safeFileName & " Where " & Status & " = '" & StatusClosed & "'", con)
Dim dasold As New OleDbDataAdapter(comm1)
dasold.Fill(dtsold)
AddColsold()
[Code] .....
It can not retrieve a date for one of the fields, then gives error and does not get dates for each records after the one it gets hung up on but the date is in the file. If I open the file in excel and play with the column sizing, for instance just autoformat column width then it read the date and will work fine. I have looked at the file in notepad and cant see anything wrong in particular on the record it gets hung up on. I have no control over the .txt file since it comes form a 3rd party.
I have an untyped-Dataset with two related DataTables, and I have a grid bound to the parent DataTable. I used the WriteXMLSchema() method of the parent DataTable in order to save the schema in a xml file. Then I opened the file with the Notepad, deleted two columns from the schema file and saved it. After that, I used the ReadXMLSchema() of this DataTable but -contrary to what I would have thought- the DataTable's structure was unchanged. Using the debugger I noticed that after calling the method the number of columns was the same. Why? How can I make the DataTable's schema to be changed by using a file?
notice that I am using the DataTable's methods and not the Dataset's because I do not want to touch the child DataTable.
Dim ds As New DataSet
Dim xmlfile As XDocument = XDocument.Load("devices.xml")
Dim reader As XmlReader = xmlfile.CreateReader
[code].....
I want to import data from excel and move that to Datatable in VB.NET 2008. I wrote and working but its taking too long time.. for 1500 records its taking 4.40 min.
[Code]...
in an winForm app in VS2010 win 7 compiling to x86, I try to do what Alvas.Audio seems to work. See (c# ex: [URL] for reference.
Dim data() As Byte = wr.ReadData(second * i, second)
The result give me data.length()=0. I do not have any exception, I can read format from it and whatever reader I use I got this problem.EDIT : After some tests, it seems like the uncompressed file I create in the first step (in PCM format, with .wav extension) can not be recognized by the Alvas.audio library for the second step. I must miss something around Audio file markups or something alike.
Here is the code that might be the source (basically this is step 1):
Dim functOut As String = String.Empty
Dim wr As Alvas.Audio.IAudioReader = Nothing
Dim fs As IO.FileStream = Nothing
[code]....
How can I write the resulted stream to be sure I can read it again later?
Im making a desktop player for a online web radio, and for the program I wanna make it show all the stream info. Like the stream name, and such. However I dont know how to do this? I looked everywhere
The server url is setup like this "[URL]" And it has all the stream info and that there. So is there a way I can get the info from there onto like say a label? Live updates btw.
Is there a way to nest a datatable into another datatable? I know you can do this with gridviews but thats not what I'm looking for.
Also, I don't want to merge the datatables. What I'm trying to do is have a datatable with 2 columns and each column containing different datatables.
i'm finishing up on my A2 Computing project now and am trying to make a few improvements. first of all, i want to fill a combo box with a list of variables from my database, so when they enter a new record on my vb form, they will have an option to choose from..
my attempt at coding:
Do
ComboBox.ObjectCollection.Equals(ds.Tables("TTDB").Rows(inc).Item("GroupID"))
inc = inc + 1
Loop Until inc = MaxRows