|
Project in VS2008.Although i searched here for fixes, i didn't find anything of use.
I saw this http://www.codeproject.com/Forums/1650/NET-Framework.aspx?fid=1650&select=2572091&tid=2572091[^] solution, but i didn't try it because it in C, and i can't translate it to VB 
Ok, there is an ACCESS DATABASE, where the user can store various information.
The database DOES have an autogenarated unique primary key.
When the user saves the record and then tries to delete right away THIS record, the "Concurrency violation: the DeleteCommand affected 0 of the expected 1 records." comes up.
However if the user reruns the program and tries to delete, everything is normal and work.
The problem is that when the user updates the database, for some reason the record does not get the normal primary key until you rerun the program.This much i know.What i dont't know, is how to fix this problem.Trying to refill the adapter after i update the record does not seem to correct it.
The code to update the database is this.
DataSet31.Tables(0).NewRow()
....
.... Part where the user fills in the information he wants to store in the database
....
....
DataSet31.Tables(0).Rows.Add()
OleDbDataAdapter3.Update(DataSet31.Tables(0))
DataSet31.Tables(0).AcceptChanges()
And the code to delete the record is this
DataSet31.Tables(0).Rows(rowindex).Delete()
OleDbDataAdapter3.Update(DataSet31.Tables(0)) <------ Here is when the problem occurs
DataSet31.Tables(0).AcceptChanges()
Thanks in advance.
modified on Saturday, November 7, 2009 4:22 AM
|
|
|
|
|
Well, some minutes later I seem to have solved the problem.
I actually ported the C, solution to VB and it solved.
Here is the solution.
On adapter rowupdated event add the following code.
Private Sub OleDbDataAdapter3_RowUpdated(ByVal sender As System.Object, ByVal e As System.Data.OleDb.OleDbRowUpdatedEventArgs) Handles OleDbDataAdapter3.RowUpdated
If (e.StatementType = StatementType.Insert) Then
Dim cmd As OleDbCommand = New OleDbCommand("SELECT @@IDENTITY", e.Command.Connection)
'If your ID field has different name than Id, replace the Id part on the next line, whith the correct
e.Row("Id") = cmd.ExecuteScalar()
e.Row.AcceptChanges()
End If
End Sub
Hope this helps
|
|
|
|
|
Hi to every one.
I am in a situation and finding the way to figure it out.
I have a web server hosting multiple web sites. Now i added some more web servers to same sub net mask. But these are not live servers. So now i want that when main server receives some requests for sites, it will transfer the request to other servers in the subnet. So that the complete bunch of requests is divided up to different servers and processed faster.
In short i want to implement a load balancing scenario. It is my own student research. No commercial work is included.
Please guide me through it. Should i implement some HTTPListener or i have write some ISAPI extension for IIS.
Thanks in advance.
|
|
|
|
|
i was able to send packets from my traffic generator to the pc, inorder for me to confirm the packets were sent i used wireshark as a visual aid. from there i saved the file as cvs and then paste data into excel sheet. once in this format i was able to do a stored procedures which put the data in a sql database. now i know there has to be a better way to both read and write captured packets to ANY database. any suggestions with steps
|
|
|
|
|
Instead of doing all that middle code (create a cvs file), why don't you buffer the records in memory and call a stored proc to add the data as it's received?
One thread plugs the data into the buffer, and one thread pulls it out and puts it in the database.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
ok imma give that a try thanks
|
|
|
|
|
I am not sure how to buffer the records in memory from.., i can you explain how
|
|
|
|
|
Create a stack of data objects, and push new ones onto the stack, and pop old ones off.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
I have this solution(vs2005 express)with different C# projects in it.
(one .exe and a few dll's that the .exe uses).
This solution works on my computer, works on several other computers(xp and vista),
but refuses to work on one particular computer.
If I rebuild everything from source on that particular computer or just copy the binaries to it, I always get this error:
"The specified module could not be found. (Exception from HRESULT: 0x8007007E)"
The program does not find a particular dll,
but the dll file is actually where it is supposed to be.
(the dll is a codelibrary I made myself)
--edit--
problem solved:
I copied about every msvc*.dll I could find to \Windows\System32...
that did the job for now (had to solve this problem fast)
modified on Friday, November 6, 2009 8:40 AM
|
|
|
|
|
Is the system where you see the problem a 64-bit OS ?
|
|
|
|
|
Public Class Form1
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Dim totaldata As String
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
totaldata = "[Grammar]" & vbCrLf & "langid = 1033" & vbCrLf & "type = cfg" & vbCrLf & "[<start>]" & vbCrLf & "<start>= Internet" & vbCrLf & "<start>= Notepad" & vbCrLf
AxDirectSR2.Deactivate()
AxDirectSR2.GrammarFromString(totaldata)
AxDirectSS1.Speak("HI ANUJA")
AxDirectSR2.Activate()
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
textbox1.text = "hi"
End Sub
Private Sub AxDirectSR2_PhraseFinish(ByVal sender As Object, ByVal e As AxACTIVELISTENPROJECTLib._DirectSREvents_PhraseFinishEvent) Handles AxDirectSR2.PhraseFinish
#If def_DirectSR2_PhraseFinish Then
Dim sFile As String
Dim noth As Long
'AxDirectSR1.get_Phrase(ActiveForm)
Phrase = "Internet"
Select Case Phrase
Case "Internet"
sFile = "C:\Program Files\Internet Explorer\iexplore.exe"
noth = Shell(sFile, 1)
Case "Firefox"
sFile = "C:\Program Files\Mozilla Firefox\firefox.exe"
noth = Shell(sFile, 1)
Case "Notepad"
sFile = "\system32\notepad.exe"
noth = ShellExecute(0, "OPEN", Environ("SystemRoot") & sFile, "", "", 1)
End Select
#End If
End Sub
End Class
I want to open internet explorer through voice. I bulid prog for dat but In this prog control is not gong to the Phrase_Finish event of AxDirectSR2.can you check this code
|
|
|
|
|
The problems seems to be that def_DirectSR2_PhraseFinish preprocessor directive is not declared. As a first troubleshooting option, try to remove the #If and #Endif statements and run your code.
|
|
|
|
|
Hi i am looking AxACTIVEVOICEPROJECTLib file, do u have this.
If yes then can u give to me
|
|
|
|
|
Hi
I am trying to insert a DataGridViewComboBoxColumn, the column is getting inserted but the values in the combo box are shown.
The Code is as under
<br />
DataGridViewComboBoxColumn column = new DataGridViewComboBoxColumn();<br />
column.HeaderText = "SELECT";<br />
column.Name = "ItemSelect";<br />
column.CellTemplate = new DataGridViewComboBoxCell();<br />
column.Items.AddRange(new string[] { "One", "One", "Three" });<br />
column.DropDownWidth = 160;<br />
column.Width = 90;<br />
column.MaxDropDownItems = 3;<br />
column.FlatStyle = FlatStyle.Flat;<br />
myDataViewGrid.Columns.Insert(0, column);<br />
<br />
When I run the code, the dataviewgrid all cells except 1st are populated properly, but in first cell I see only empty combobox
Please guide
Thanks in advance
|
|
|
|
|
How can i know that my text in a richtextbox reached the to the maximum visible height or width of my richtextbox.can anyone pls help..
|
|
|
|
|
I would like to write(modify) a sink for Exchange 2003 that will read a subject line and call an external script/exe based on the subject line.
However, all the sink examples I see/download give me hundreds of errors trying to build them with Visual Studio 2008
Does anyone know of a good place to start?
|
|
|
|
|
Craig Henderson Qvai wrote: Does anyone know of a good place to start?
I hate to state the obvious but go back to the samples. If they give errors when you try to build them then you need to find out why and fix the issue. The chances are that most of these samples will build if you set your environment up correctly. Check the prerequisites in terms of libraries, extra include files, COM objects etc.
|
|
|
|
|
Hi,
I tried to run my old MFC multi-threading program on PC with .NET 2.0 and it doesn't work as it used to.
So I made a test with console application.
My application dynamically loads .dll function with LoadModule and GetProcAddress.
When I tried it in single thread, then it works.
When I load module in main thread and then I call imported function in another thread, it fails.
When I load module in new created thread where I call imported function, it works.
My question is:
It is consequence of .NET Framework ?
I was looking for some implementation of thread safe calling in VS6, but I didn't found anything suitable.
|
|
|
|
|
rudozkv_new wrote: It is consequence of .NET Framework ?
No, MFC programs are pure C++ and don't use .NET. It looks like your cross thread code is wrong but somehow did not show up previously.
|
|
|
|
|
I need to run a program that uses .NET 1.1 however when I try to install it gives error "cannot install because other version of the product already installed". So, I uninstalled all versions of .Net and rebooted and it still gives the same message "cannot install becuase other version of the product already installed"
Any ideas?
|
|
|
|
|
Possibly create a virtual machine to run this in isolation. I assume though that you can't recompile this application and target a new version of the .NET Framework.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
All .NET versions can coexist, they use different folders and version numbers.
It sounds to me it is the application itself, not the .NET Framework, that is already (partially) installed.
Also, I suggest you give the error message verbatim, either in your post, or to Google.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
|
Ah, in the end I just gave up and used a different program. Anyways thanks for the answer
|
|
|
|
|
pls Niland help me. An exception is being raised when i try to connect to any mail server and the code you provided is unable to solve this. pls help me. 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Java | [Coffee]](https://www.codeproject.com/script/Forums/Images/coffee.gif)