My problem comes when i'm trying to read the 'filePathName' and the 'fileToken'the privious SELECT GET_FILESTREAM.... return me only one colomn to read the colomn 0 which has the GUID in binary format I know i'm doing something wrong but i don't know what My issue is that i'm not geting th 'filePathName' and the fileToken'?
I have a small problem with this code. I am adding information to my listview from multiple textboxes. As I add the info I automatically update a text file with the code shown below. The problem I have is When I add my first row the code will not write the data back to the text file, however if I add a second row the code is quite happy to write both rows of data back to the text file. I cannot for the life of me see what is wrong.
'Write tool info to text file Dim outputstream As StreamWriter = File.CreateText("C:\MFSProFiles\" & CObj(PartNoTextBox.Text) & ".tme")
Just starting up on VB 2008 Express (.NET). Trying to write to and read from a file. It runs without errors, but the messagebox only shows the 'OK' button, not the contents of the file as I want. I thought that maybe I have to rewind the file before reading, but AFAICS there is no 'StreamRead.Rewind' or Reset or something.
This app is trying to send messages to a client listening on the port. The client's logs show that their port is being opened and closed, but no data coming in. Is there a bug or something missing in the following code, like perhaps stream.flush or stream.endwrite or a thread.sleep(0) line, that could cause this? The puzzling thing is, WireShark on the client computer does show the message my app is sending coming into the listening port.
I am trying to test a rest webservice but when I do a post and try to retreive the save the response stream to a file I get an exception saying "Stream was not readable." What am I doing wrong?
Lets say I wanna write a string "Hello World" into a MemoryStream and read this string to MessageBox.Show() without using Helper objects such as BinaryWriter and BinaryReader and StreamWriter and StreamReader etc.
how to accomplish this with low-level functions of MemoryStream stream object.
i have made tcp connection to this webpage using tcpclienti can send commands like GET /Pagename.aspx to get the htmlnow is it possible that from webpage.aspx i can get the connected client stream and write to it and tcpclient gets that data ?
I have this code that was working in a proof of concept app I had - but now will not work.
For Each ddfile As String In ddfiles Dim MyThread As Thread ' simple new thread Dim newFS As FSObject = New FSObject() 'new FSObject which is a file object I made up' used because i needed to keep the name and index matched so the callback function had something to work with
I wanted to know what (if any) differences there are to using the SQL Transaction within the application versus written into the stored procedure using TSQL statement. We would need to restructure the stored procs and vb code to get this to work and I'm not sure it would be worth the effort at this time.
Public Sub RetrieveTData(ByVal cID As String, ByVal cnn As SqlConnection) As Boolean Dim sqlTran As SqlTransaction cnn.Open() sqlTran = cnn.BeginTransaction
[code].....
We aren't certain whether the timeout is occurring in DataAlreadyTransferred() or usp_BigNasty_CopyDataFromDB1toDB2 due to how the try/catch is written. We can restructure this code, but will take a week or so to get it to production (no errors occur on test/dev today)
DB1 - permanent storage, used by other applications as well DB2 - working set, used only by Web App
DataAlreadyTransferred(cID) first checks to see if DB2 has any copies of the records, if DB2 does and those records are clean it deletes them (data could have changed in DB1 and we want the most up-to-date version). If DB2's data is dirty it is left alone and no data is deleted.
usp_BigNasty_CopyDataFromDB1toDB2 copies rows from approximately 20-30 different tables and copies over the perm copies from DB1 into DB2, essentially creating a working set from which the Web App can access
We are aware this is inefficient and are examining ways to improve it, just haven't had time yet... I believe by having the transactions in the app code it's locking many more tables than is really needed. If we move them to the stored procs, less tables will be locked at one time thus improving our chances of removing deadlock conditions/timeout issues we're seeing today. Just not sure on this..
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?
I've found solutions to determine the length of an audio file using WMPLib.WindowsMediaPlayer (which seems quite ugly), by using a physical file path, but nothing to determine the duration of an audio file stored in a VARBINARY field (SQL Server 2008 R2).I'm using .Net WebForms. Maybe it'd be a better idea to do this client side with jQuery, but what if I only want to expose some controls to the web browser based off of the duration?
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.
i have a situation where I need to search a table for a specific record that matches an ID number the user will specify. I know 2 methods to accomplish this. The first would involve writing some VB.net code that would call a TSQL statement and return the value through the return parameter. The second method would involve creating a dataset and populating it with a select statement.
I have a VB.Net program that will basically make a query to a remote MS-SQL DB using TSQL, return two columns (normally 4 rows/records), 1 is a datetime and 1 is a double. I will then need to return the average of the doubles (which is easy in VB.NET).
As I will need to run this query perhaps 1000 times an hour (programmatically with different input parameters for the query), I am looking for the most efficient way to code this up so that it will take the shortest time to run. I tried SQLDataAdapter and then using dataAdapter.Fill and sometimes it returns an empty set although the raw select query has values returned.
Struggling again with doing in VB what I find simple in TSQL (sigh) - hoping that a forum member can point me in the right direction again. I have a datatable with three columns :- A, B & C I am looking to count the number of records in the datatable where columns B & C (both numeric) match specific criteria. eg :-
I built a prototype system with some database queries. Since it was just a prototype and I was very new to databases, I just used a direct string. This is the string I used and it works fine:
command = New OleDbCommand("SELECT * FROM " + prefix + "CanonicForms WHERE Type=1 AND Canonic_Form='" + item + "'", dictionary_connection)
Now, in putting it in a real system, I wanted to use the more secure parametized method, so after some googling I came up with this:
command = New OleDbCommand("SELECT * FROM @prefix WHERE Type=1 AND Canonic_Form=@form", dictionary_connection) command.Parameters.AddWithValue("@prefix", prefix + "CanonicForms") command.Parameters.AddWithValue("@form", item)
But all I get is an error for an incomplete query clause. What have I done differently between the two?
From within my VB.Net program, I would like to write to one specific column of a row in a table in an SQL database, given the row's primary key. What is the lowest-overhead means of doing this? I understand how to create a table adapter, fill a datatable, write to the datatable and then update the database. Is there a relatively simple way to directly access the database table instead?
as a comparative newbie to VB, I am having trouble with a program I am writing in Visual Studio 2005 in order to insert a value into a table I have previously created with SQL Server. Here is the function that is giving me trouble
and in both table i have to insert values and later i need to update one table... the problem is when there is any exceptions in update it need to rollback fully and it also the values which have been inserted must be rollback..
I have a problem with the cryptostream, if i write the stream to a memorystream the memory that the stream used is still alocated and i have no way of unalocating it.what am i missingdoing wrong? im using-using on the streams,readers and crypto stuffs so the framework should shut them all down right? i tryed calling .close and .dispose but nothing ,in fact i moved it all over I have provided the sub that im using for the encrytion im in .net 4.5 so there is a lil async stuff but i know thats not the problem coz i moved this code out of my main app(.net 4) for testing to see if i could fix the problem.[code...]
I want to read from one Table in a database and write the information to another Table in the same database. It's all connected but I just can't get it to work at all.
How to use SqlTransaction in .net 2.0 so that when I start reading data from a table, that table is blocked for others (other programs) to read/write to that table? If SqlTransaction is not a good option, than what is?
I would like write Date and Time from Now() To field fDT in Table Tbl MS Access 2007 but I can't: msAccessConnection.Execute("INSERT INTO Tbl (fDT) VALUES ('" & DateTime.Now & "')")
