|
My guess is that in your table1tableadapter you have a select command and an update command, but not a delete command. When using a tableadapter these sql statements need to be defined.
This is what MS help says:
If INSERT, UPDATE, or DELETE statements have not been specified, the Update method generates an exception. However, you can create a SqlCommandBuilder or OleDbCommandBuilder object to automatically generate SQL statements for single-table updates if you set the SelectCommand property of a .NET Framework data provider. Then, any additional SQL statements that you do not set are generated by the CommandBuilder. This generation logic requires key column information to be present in the DataSet. For more information see Automatically Generating Commands.
Hope that helps.
Ben
-- modified at 22:24 Monday 1st October, 2007
|
|
|
|
|
ok thanks.. I'll try to check this out and how it will work..
I'll just ask here again if I have some questions..
|
|
|
|
|
I wanted to read the article in following heading
Automaticaly Match and Select ComboBox Item
did everything as is on the tutoriaL. but when i type in the combobox it doesnt set the correct text in the cmbbox.text field..
I am using vb.net not vb6. i changed the VB.LEFT to Microsoft.Visualbasic.Left.
what may be the problem?
fire
|
|
|
|
|
firebladeiii wrote: I wanted to read the article in following heading
Automaticaly Match and Select ComboBox Item
Did you find it here? If so, do an article search to find it again.
firebladeiii wrote: I am using vb.net not vb6. i changed the VB.LEFT to Microsoft.Visualbasic.Left.
what may be the problem?
Find the article and post a message. See if the author responds.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
I have a web service project created using VS 2005(vb.net). I have a web method exposed that will be used by a remote client. I also want to fire the code in this method when the web app that exposes the web service starts (say from Application_Start in Global.asax).
Is there a way I can call this method from Global.asax?
Matt Melick, MCSE MCT
|
|
|
|
|
|
Thank you for the response but server.execute would not not be the proper way to access the public method within the service class.
|
|
|
|
|
sorry you did say webservice didn't you.... wouldn't you have to use an http call using either dotnet code or msxml dll?
you could also put the functionality into a dll. have your webservice reference that dll and your global.asax could do a load assembly to the same dll.
|
|
|
|
|
Further isolating the code may work but was hoping there would be a simple way to get to the method since its contained in a public class. Its possible I'm looking for an answer that doesn't exist, it jsut seems kind of limiting that once you enclose a sub in web method brackets that it can't some how be accessed through internal code.
|
|
|
|
|
I forgot how to do this and I am not exactly sure how to search for it. But I am displaying 2 texts in the same label but I want them to be on different lines. I have seen it before but I have forgotten how to do it can someone please help me!
Thank You!
|
|
|
|
|
use "\n" inside a string or look at the example below:
label1.Text = "foo" & System.Environment.NewLine & "second line"
|
|
|
|
|
I am trying to connect to the database through Microsoft by doing new project and selecting database but does not seem to be working, this is a new venture for me and i have an assignment that says i must do a database with oracle consisting of 3 or 4 tables and by use of VB.Net retrieve the information from the oracle database.
Thank You Beforehand
Kendo
|
|
|
|
|
Which part is not working ? Do you have Oracle running ? Do you know how to connect to SQL Server and the issue is Oracle ? There are Oracle specific classes in .NET, have you looked at the help for them ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
i am reading up online at present and have been for the last 4 days but i just dont understand at present. Last year i created a database with access with front end VB.NET. Theatre booking system.
But i have never used oracle before and i just keep reading up online from oracle site but just keep bashing my head against a brick wall. I can get oracle running and go into create the table. I do not know how to connect to the SQL server.
Thank you
Its not that i am not reading up and trying to do on my own just seem to get know further than i was 4 days ago.
I will need all the luck i can get as Final Year Degree.
|
|
|
|
|
|
i have been to that document but clicked on other links on it but that looks to be the source that i am looking for just so much oracle and .net about out there which is confusing me.
Christian Thank You for the help i will work through that and will let you know how i get on.
You will never know until you give it a go!!!!
|
|
|
|
|
I have done what the link says but i dont seem to get any details back, the following does not copy and paste into SQL*Plus:
Listing 1
DROP TABLE emptab; <br />
CREATE TABLE emptab (empno NUMBER(4) PRIMARY KEY, ename VARCHAR2(10));<br />
INSERT INTO emptab VALUES ( 1, 'Mark');<br />
INSERT INTO emptab VALUES ( 2, 'Roger');<br />
INSERT INTO emptab VALUES ( 3, 'Crook');<br />
COMMIT;
I have typed it several times into the SQL*plus command prompt window but just keep getting SP2-0640: Not connected
below is print screen of walk through.
I take it you cannot post word docs in here.
When i type it in the SQL*plus command prompt window the SQL that is typed just stays on the same line until i get to the end of screen then jumps on to the next line. Is this the problem.
I have entered all the VB.net code in and dont have any errors in the code but i must display the details into some list box at present but and eventually into text boxes. Cant remember how to do this will get last years work out.
-- modified at 5:36 Tuesday 2nd October, 2007
|
|
|
|
|
Hi,
This is going to be a bih question but please if you can help me in any way.
I am building a application that is creating wav files. I have managed to create a wav file but I need to insert a pause in the WAV - a straight line, no sound. but still part of the wav. The code is following:
Dim i As Long
Dim lngLimit As Double
Dim lngDataL, lngDataR As Double
Dim dblDataPt As Double
Dim blnPositive As Boolean
Dim intCycleCount As Integer
Dim lngFileSize As Double
Dim lngSamples As Double
Dim lngDataSize As Double
Dim dblDataSlice As Double
Dim dblWaveTime As Double
Dim dblTotalTime As Double
Dim dblSampleTime As Double
dblFrequency = Frequency
'If dblFrequency > 1000 Then
' intCycles = 100
'Else
' intCycles = 10
'End If
intCycles = CInt(trajanje)
dblWaveTime = 1 / dblFrequency
dblTotalTime = dblWaveTime * intCycles
dblSampleTime = 1 / CDbl(lngSampleRate)
dblDataSlice = (2 * PI) / (dblWaveTime / dblSampleTime)
lngSamples = 0
intCycleCount = 0
blnPositive = True
Do
dblDataPt = System.Math.Sin(lngSamples * dblDataSlice)
If lngSamples > 0 Then
If dblDataPt < 0 Then
blnPositive = False
Else
' Detect Zero Crossing
If Not blnPositive Then
intCycleCount = intCycleCount + 1
If intCycleCount >= intCycles Then Exit Do
blnPositive = True
End If
End If
End If
lngSamples = lngSamples + 1
Loop
'-------------------------------------------------------------------------------
' Bytes 40 - 43 Length of Data Samples * Channels * Bits per Sample / 8
'-------------------------------------------------------------------------------
lngDataSize = lngSamples * intAudioWidth * (intBits / 8)
ReDim Preserve WavArray(0 To 43 + lngDataSize)
WavArray(40) = ExtractByte(lngDataSize, 0)
WavArray(41) = ExtractByte(lngDataSize, 1)
WavArray(42) = ExtractByte(lngDataSize, 2)
WavArray(43) = ExtractByte(lngDataSize, 3)
'-------------------------------------------------------------------------------
' Bytes 04 - 07 Total Length to Follow (Length of File - 8)
'-------------------------------------------------------------------------------
lngFileSize = lngDataSize + 36
WavArray(4) = ExtractByte(lngFileSize, 0)
WavArray(5) = ExtractByte(lngFileSize, 1)
WavArray(6) = ExtractByte(lngFileSize, 2)
WavArray(7) = ExtractByte(lngFileSize, 3)
'-------------------------------------------------------------------------------
' Bytes 44 - End Data Samples
'-------------------------------------------------------------------------------
If intBits = 8 Then
lngLimit = 127
Else
lngLimit = 32767
End If
For i = 0 To lngSamples - 1
If intBits = 8 Then
'-----------------------------------------------------------------------
' 8 Bit Data
'-----------------------------------------------------------------------
' Calculate data point.
dblDataPt = System.Math.Sin(i * dblDataSlice) * lngLimit
lngDataL = Int(dblDataPt * dblVolumeL) + lngLimit
lngDataR = Int(dblDataPt * dblVolumeR) + lngLimit
' Place data point in wave tile.
If intAudioMode = MODE_MONO Then WavArray(i + 44) = ExtractByte(lngDataL, 0)
If intAudioMode = MODE_LR Then 'L+R stereo
WavArray((2 * i) + 44) = ExtractByte(lngDataL, 0)
WavArray((2 * i) + 45) = ExtractByte(lngDataR, 0)
End If
If intAudioMode = MODE_L Then ' L only stereo
WavArray((2 * i) + 44) = ExtractByte(lngDataL, 0)
WavArray((2 * i) + 45) = 0
End If
If intAudioMode = MODE_R Then ' R only stereo
WavArray((2 * i) + 44) = 0
WavArray((2 * i) + 45) = ExtractByte(lngDataR, 0)
End If
Else
'-----------------------------------------------------------------------
' 16 Bit Data
'-----------------------------------------------------------------------
' Calculate data point.
dblDataPt = System.Math.Sin(i * dblDataSlice) * lngLimit
lngDataL = Int(dblDataPt * dblVolumeL)
lngDataR = Int(dblDataPt * dblVolumeR)
' Place data point in wave tile.
If intAudioMode = MODE_MONO Then
WavArray((2 * i) + 44) = ExtractByte(lngDataL, 0)
WavArray((2 * i) + 45) = ExtractByte(lngDataL, 1)
End If
If intAudioMode = MODE_LR Then
WavArray((4 * i) + 44) = ExtractByte(lngDataL, 0)
WavArray((4 * i) + 45) = ExtractByte(lngDataL, 1)
WavArray((4 * i) + 46) = ExtractByte(lngDataR, 0)
WavArray((4 * i) + 47) = ExtractByte(lngDataR, 1)
End If
If intAudioMode = MODE_L Then
WavArray((4 * i) + 44) = ExtractByte(lngDataL, 0)
WavArray((4 * i) + 45) = ExtractByte(lngDataL, 1)
WavArray((4 * i) + 46) = 0
WavArray((4 * i) + 47) = 0
End If
If intAudioMode = MODE_R Then
WavArray((4 * i) + 44) = 0
WavArray((4 * i) + 45) = 0
WavArray((4 * i) + 46) = ExtractByte(lngDataR, 0)
WavArray((4 * i) + 47) = ExtractByte(lngDataR, 1)
End If
End If
Next
this is the function that creates the array. another function just writes the wav as binary writer, and all is good. I get a perfect result; a perfect sine wave. But i need to insert some pauses -SILENCE that is in the WAV.
This is a great challenge for me, maybe it will be for you too.
Please help.
Thank you.
|
|
|
|
|
I'm pretty sure that if you just write a stream of zeros in a 16 bit file or a stream of 127s or 128s in an 8 bit file then you should get no sound. Actually any number as long as it stays the same and doesn't vary should produce no sound.
Basically the loudness of a noise is just the difference between its highest air pressure and its lowest air pressure. When the numbers in a wave file go to the speaker it causes it to push something back and forth depending on what the number is and this vibration creates the noise. And all a microphone does is record air pressure at a given moment in time.
|
|
|
|
|
i have been looking for a way to find the number of files in a folder and if there is more the n
number of files in that folder delete the oldest ones. i have fount a way to count the number of
files in the folder, but i am not having any look in finding something to help me in deleting the
oldest files. any guidance would be helpful.
I'm using Vb.net 2.0.
|
|
|
|
|
Above your code write Imports System.IO. Then check out the possibilities of File (File.Exists, File.GetCreationTime, etc)
Good luck,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
this line gets the count System.IO.Directory.GetFiles("c:\").Length
|
|
|
|
|
i had already fount a way to do this but this is alot simpler. So thanks
|
|
|
|
|
You can have a function which will find the oldest file in a given directory and then you may delete it.
Call this function in a loop while System.IO.Directory.GetFiles("Path").Length>n.
Following is such a small function which finds the oldest file at the given path and removes it –
-------------------Start Code--------------
Private Sub RemoveOldFiles()
Dim str() As String
str = System.IO.Directory.GetFiles("Path")
Dim d As Date
Dim oldfile As String
d = Now()
For Each fl As String In System.IO.Directory.GetFiles("Path")
If d > System.IO.File.GetCreationTime(fl) Then
oldfile = fl
d = System.IO.File.GetCreationTime(fl)
End If
Next
System.IO.File.Delete(oldfile)
End Sub
--------------End Sub-------------------
I hope this helps .
-Dave.
Dave Traister,
ComponentOne LLC.
www.componentone.com
|
|
|
|
|
Thanks
this is just what i needed. it works perfectly for what i need
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
