Tsql - Get The Duration Of T-SQL VARBINARY Audio In SQL Or .Net?
Nov 10, 2011
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?
View 1 Replies
ADVERTISEMENT
Jun 21, 2010
according to the formula given by DdoubleD i resolve DSS audio file duration problem, but this time some dss file is more compressed and duration of these file different according to size of file. IS there is any technique in .net 2005 so that i can include any third party's player and find duration and other thing I tried to include DLL of these player but not compatible with .net..DSS file is basically dictation by doctor(olympus recorder is use to record dictation and it save these file in .dss format) I already included WMP.dll for MP3. But .dss is creating problem.
View 1 Replies
Mar 11, 2010
i want to retrieve duration of audio file like .wav .dss .mp3 using vb.net code...
View 2 Replies
Jan 28, 2010
I'm developing a standslone system for my school project. I'm developing an audio management system which allow user to add audio files itself into database together with the audio information such as artist name and album year. I just started it few days ago and face some problems.. my song in the playlist wont continue to play after 1 finished and i need some idea on how to store the audio files into database ... in blob types may be?
Heres the screenshot and codes
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bt_add.Click
[CODE]............................
View 2 Replies
Oct 7, 2009
I wanted code to convert the varbinry to pdf and save it on Clients machine.
View 4 Replies
Mar 13, 2009
I just want to ask or I need some idea on how to convert wav files to mp3 and compressed the file to make the size smaller. I've search on the internet and find vorbis.dll as a reference object and lame.exe for converter. With regards to the audio compression, i downloaded monkey's audio software but doesnt have an idea on how to incorporate it.
View 2 Replies
Jun 11, 2009
Im trying to capture the audio played on my laptop. so i have searched the internet and found a source code for doing exactly that. the problem i have is that my audio device is not listed in the dropdown box (see picture) but it does when its run on windows xp (im running windows 7 x64) the goal of this application would be to capture my friends radio stream and save the individual played mp3's to a loction on my hard drive.(yes i have permission) i have included the source code so perhaps some 1 could have a look at it. (source code)[URL]
View 2 Replies
Feb 26, 2007
make a VU meter for Audio to monitor audio input devices volume level such as microphone and etc?
View 7 Replies
May 20, 2009
I have a database application developed around Access with VBA,I have used the Speech SDK and developed an application that in conjunction with MSCOMM 6.0 library calls into a remote IVR system.It sends in the credentials and queries information in response to that IVR's verbal requests. All seems successfull except for one problem;I'm using a shared SR engine and its using the system microphone as its audio input, this in turn gets the sound from the speakers which are routed to the telephone line through the modem. Of course this has a number of disadvantages - noise added to the sound from the environment and sound quality degredation as well as speaker volume dependency.
I would like the SR engine to take its audio input from the modem in paralell with the sound that goes to the speakers (so we can listen in to the call as well). This means that I must route the system audio output to the SR engine audio input. It seems that I must use an InProc SR instance - however in VBA that type is not recognized - since the shared SR uses the microphone as input by default. there is some statement to the effect that it is difficult in Microsoft's Help file. I'm unable to set the SR audio input to the modem output stream in VBA.As needed I can accomplish the C++ interface using an ActiveX object or a DLL to expose the missing API to VBA?
View 7 Replies
Apr 3, 2010
I am writing a small app that reads in a .pdf file using the below parser to a Varbinary(Max) column in a sql table[code]....
View 1 Replies
Jun 10, 2009
A partner of ours is making a call to a web service that includes a parameter called token. Token is the result of an MD5 hash of two numbers, and helps us authenticate that the user using our partners system. Our partner asks the user for two strings, concatenates them, runs them through MD5, and then calls our web service. The result of the MD5 is the token, and it is submitted to us as a string.
We store valid tokens in a DB - since we use the SQL Server to compute the tokens on our end, SQL seemed to be happiest storing the tokens as a varbinary, which is its native result for an MD5 computation.
We have two pieces of code that attempt to do the same thing - run a select query that pulls out a value based on the token submitted. One uses a dynamic query (which is a problem), but it works. The other one attempts to do the same thing in a parameterized (safer) fashion, it does not work - it is unable to locate the token.
Here's the two competing attempts. First, the parameterized version which fails:
byteArrayToken = System.Text.UnicodeEncoding.Unicode.GetBytes(stringToken)
scSelectThing.CommandText = "select thing from tokenstable where token=@token"
Dim param As SqlParameter = scSelectThing.Parameters.Add("@token",
[Code].....
View 1 Replies
Jan 25, 2011
I have a problem which I have not been able to find an answer to in months. I store word doc resumes as varbinary(max). I can retrieve the resumes based on a full-text search no problem. But the resumes are retrieved as word documents in a .ashx file with the following code. I really need to implement hit highlighting on the site so that users can see if the returned resume is a good fit or not.
I don't think this can be done from an .ashx file, so I think I need to be able to open the resume as html in an aspx page and maybe use javascript to do the hit highlighting or perhaps return the text only content of the word document somehow and manipulate the text before display with html tags.
[Code]...
View 1 Replies
Aug 3, 2009
I'm trying to test a varbinary(max) field to see if it's null. I'm trying to figure out if it's a null or not in the select statement, hoping to avoid having to do this locally for every row of the returned dataset. This is the SQL I'm using,
[Code]....
View 1 Replies
Nov 19, 2010
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..
View 2 Replies
Feb 3, 2009
i ised char index of TSQL in vb.net This is my sample script..
strCreditCardName = case when substring(insertedset.EncryptedAccountData, 0, 13) <> 'AccountName=' THEN '' ELSE substring(REPLACE(substring(insertedSet.EncryptedAccountData, charindex('AccountName=', insertedSet.EncryptedAccountData) + 12, charindex('&AccountNumber=', insertedSet.EncryptedAccountData) - 13), '+', ' '), 0, 50) END
View 1 Replies
Jun 23, 2010
I have following code and I can filter data on grid but when I pick same date in 2 datepicker it shows nothing. How can I fix the problem.
[Code]...
View 6 Replies
Oct 13, 2010
I use a VARBINARY(MAX) column, because I have no idea what is going to be put into it. All I know is that as of this point in time, the data will be one of many traditional data types(Integer, String, DateTime, etc.)I also have another column that is meant to indicate the DataType so the .NET application can handle the data and validate input accordingly.Right now, for testing, I have a DataType table in my database that stores the "supported" datatypes for the VARBINARY column, and a foreign key linking to the column meant to indicate the DataType. This works perfectly, but it feels akward.
View 2 Replies
Jun 5, 2012
When I try to query an entity that has a varbinary field in it I am getting error:"The LINQ expression node type 'ArrayIndex' is not supported in LINQ to Entities."
Here is my query:
Dim query = From entity In db.Entity
Where entity.Id= Id
Select entity.VarBinaryField
[code]....
The error gets generated when I check that the query isNot nothing.
View 1 Replies
Jan 4, 2011
I am using VISUAL BASIC 2010, SQL Server 2008. I need to update a Table with SQlDbType Varbinary. Just for sake of Murphy loving me I gave it Varbinary(100) - while max. field lenght is 20 Non Ascii Characters on the UI Side.User is changing data in a form, data gets encrypted (into a Byte Array) then sent to the BL of the program, the business logic talks to SQL Server and fields in the Table are updated nicely with new binary values.
A problem arises however with a field that is allowed NULL values in the data table. I can retrieve NULL values from the Database and assign them the "Nothing" value. (User Interface shows a nice blank field). Once the user however changes that empty field(containing "Nothing" as value) with any data then my cmdSql.ExecuteNonquery reports no changes. (rowsaffected = 0)
I strongly suspect that I am making a mistake in the parameters of the SQlCommand of the OldFullname value, but as I said I am staring myself blind. Please review my code below and tell me where I am making that mistake...
FYI: OldFullname can't be "Nothing", and its current field is SQL NULL. All fields (except UserId) are Varbinary. Update succeeds as long as OldFullname SQL field contains data - only not when it is NULL. I don't want to set a standard value on the column (NULL or such).
Public Function SaveToDatabase(ByVal OldUser As blProgramAccess.userEncrypted, ByVal NewUser As blProgramAccess.userEncrypted) As Boolean
Dim bSaved As Boolean[code]....
View 6 Replies
Jun 27, 2012
i'm using the following code in order to send the bytes of a picture into the stream table:
Dim FirstColumnNames As String = imTable(0) & "_Code, " & imTable(0) & "_Price, " & imTable(0) & "_Title, " & imTable(0) & "_Type, " & imTable(0) & "_Height, " & imTable(0) & "_Width, " & imTable(0) & "_Comments "
Dim FirstFieldsValues As String = "'" & imParam(1) & "', '" & imParam(2) & "', '" & imParam(0) & "', '" & imType.ToString & "', '" & imHeight & "', '" & imWidth & "', '" & imParam(3) & "' "
[code]....
The tables have the fllowing stracture Thats the First Table:
myCommand = New SqlCommand("CREATE TABLE " & TablesStat(0, 0) & _
" (" & TablesStat(0, 0) & "_ID int NOT NULL PRIMARY KEY IDENTITY(1,1), " & TablesStat(0, 0) & "_Code varchar(20) NULL, " & TablesStat(0, 0) & "_Price money NULL, " & TablesStat(0, 0) & "_Title varchar(50) NULL, " & TablesStat(0, 0)
[code]....
End the second table is:
myCommand = New SqlCommand("CREATE TABLE " & TablesStat(1, 0) & _
" (" & TablesStat(1, 0) & "_ID int NOT NULL PRIMARY KEY IDENTITY(1,1), " & TablesStat(1, 0) & "_GUID UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL UNIQUE , " & TablesStat(1, 0) & "_" & TablesStat(0, 0) & "_ID int FOREIGN KEY REFERENCES " & TablesStat(0, 0) & " (" &
[code]....
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'?
View 3 Replies
Aug 30, 2010
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.
View 2 Replies
May 14, 2011
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.
View 2 Replies
May 13, 2011
In VB.NET, how do I do the following?
Execute a Stored Procedure
Read through the DataTable returned
View 2 Replies
Oct 15, 2011
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 :-
View 3 Replies
Sep 23, 2009
how can i play the audio after the previous audio play is finish by using directx.
assume i have audio1.wav and audio2.wav.
i play audio1.wav by this code.
audio1 = audio.fromfile("D:audio1.wav", false)
how can i play audio2.wav after audio1.wav is finish? without use any button or signal. just depends on when the audio1.wav is finish, then audio2.wav will play automatically.
View 4 Replies
Jul 11, 2011
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?
View 3 Replies
Jun 25, 2011
i want to use code to get the video duration, then I need to upload to servermy os is WINDOW SERVER 2007, anycode can support it?
View 3 Replies
May 14, 2012
I want to retrieve the duration, frames, fps and dimensions (height x width) of a .mov/.avi files..Can any one say how can i get these...PBL (Visual Studio 2010 Professional, Win 7 64 bit Ultimate)
View 4 Replies
Mar 23, 2010
how can i create a video duration bar so that if i add a video in listbox the duration bar should automatically increas its total duration and display the duration on it....just like in any video editing software...
View 1 Replies
Sep 11, 2009
We have create a VB.NET app (exe) that is called by our non-vb.net software app.The .NET app is a Windows Application module. The only form presented on it is when users are previewing a Crystal Report.Otherwise, we are just executing code from the module. What we want to do is set the cursor to an hourglass from the moment our vb.net app(exe) is executed until it has closed.I have tried entering Cursor.Current = Cursors.Wait as the first line in the code, then Cursor.Current = Cursors.Default just before exiting the Main subroutine. But, this does not work.
How can I control the cursor on, essentially, a non-form vb.net application?
View 5 Replies
