|
Just query the database to see if the data exists, if it doesn't, call your insert method.
This requires two calls to the server and could prove costly. You should do this in your Stored Procedure on the server.
I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
Why don't you set up the database columns to not accept Duplicate values. This would negate 2 calls to the database and would make your inserts faster.
|
|
|
|
|
You are doing it again.
Please do not post the same question again, and again.
If you do not get an answer right away, have patience. People will answer in their own good time, not in yours.
When you do not understand the answer, or if you think that people have not understood your question, and you want to ask your question in other words, use the same post. At the bottom of each answer is a Reply link. Please, please, please, use it.
That way it will be easier for people to understand your problem and help you find a solution.
Creating a new post each time, is unnecessary and irritates a lot of people here.
My advice is free, and you may get what you paid for.
|
|
|
|
|
faisalali_78 wrote: Avoid inserting a duplicate record using vb.net
OK, I will.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
Try also to avoid it using C++, C#, COBOL, PYTHON, VB6, VBA, JAVA, and any other language you can think of / know how to use.
My advice is free, and you may get what you paid for.
|
|
|
|
|
Great idea. Thanks for the tip!
|
|
|
|
|
avoiding duplication, how we can check before inserting data in a table in vb.net
|
|
|
|
|
Erhm... perform a select before you insert?
|
|
|
|
|
Hello,everyone!Need help about adding controls.Now I want to do this:if there is one pannel with some controls such as text box or combo box,when I clicked the button "Add" ,a same pannel wiht same controls would display under the first pannel;then the button "Add" go down below the second pannel.Then I clicked button once again,there will be three same peannel.
What I should do to achieve this ?Please give me some suggestions!Thanks a lot!
modified on Tuesday, May 18, 2010 10:44 PM
|
|
|
|
|
For a WinForm app, there seem to be two very different ways to add controls to a form:
- one is by using the "Visual Designer"
- the other is by adding some code that creates and adds controls at run-time.
However, the designer basically does two things for you:
1. it adds code to some file, which you may not have seen yet; if your form is called Form1, it consists of several files, including Form1.vb; the designer creates and controls Form1.designer.vb (you may have to fiddle some buttons/settings for Studio to show it in the Solution pane, can't remember the details).
2. and then it lets Studio execute such code, and that is how the controls suddenly appear on you form. (No they are not really drag-and-dropped, your drag operation tells the Designer to add and then execute code!)
So the suggestion is clear: do it once with designer, then go and peek inside that auto-generated file.
BTW: do not edit the designer files, just learn from them, and add similar things to your code.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
Maybe it is not so curious, but it is to me at least.
I have a system.timers.timer declared and set up and then the code executes the final line in the routine is ProcessDuplicateMessage.
In the ProcessDuplicateMessage routine I get this error:
System.InvalidOperationException was unhandled by user code
Message="Cross-thread operation not valid: Control 'lblReviewValue' accessed from a thread other than the thread it was created on."
Source="System.Windows.Forms"
StackTrace:
at System.Windows.Forms.Control.get_Handle()
at System.Windows.Forms.Control.set_WindowText(String value)
at System.Windows.Forms.Control.set_Text(String value)
at System.Windows.Forms.Label.set_Text(String value)
at ....FImportMsgProcess.ProcessDuplicateMessage() in C:\....\FImportMsgProcess.vb:line 41
at ....FImportMsgProcess.FormLoadComplete(Object sender, ElapsedEventArgs e) in C:\....\FImportMsgProcess.vb:line 134
at System.Timers.Timer.MyTimerCallback(Object state)
Now obviously this is something to do with the timer, which I assume is running in a different thread, but my question is:
How do I return the process to the thread for the form before calling the next routine.
If I remove the system.timers.timer and add a forms.timer I don't get the problem.
Just curious really since I have cured the immediate problem by using a forms.timer instead and I would like to know for another occasion.
|
|
|
|
|
You're correct about the System.Timers.Timer "firing" your code on a seperate thread. Docs on the Timer class are here[^]
You also cannot access UI controls from any other thread other than the thread that created the control, i.e.: the UI (or startup) thread. A good article on the hows and whys of this can be found here[^].
|
|
|
|
|
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
When I find a good article, I run with it.
|
|
|
|
|
I'll try and create some more then...
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
Thanks Dave, and of course Luc for the article.
|
|
|
|
|
You're welcome.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
I have just rewritten some shared code to put it into namespaces so that it will be easier to find.
After adding this stuff to namespaces now my code does not work because I am not importing the namespaces on each form.
I know that you can import namespaces for the entire project in properties but I am wondering is this something that will hurt performance.
Even if it will not hurt performance is there another way that I can only import the namespaces into the code files that actually use them because I am not wanting them at project level because while that will make my code work.., it defeats the reason for doing this to begin with which is to narrow the amount of things showing up in intellisense.
I hope that is clear enough if not please just tell me.
Thanks,
Brian
Humble Programmer
|
|
|
|
|
You need to import namespaces only in the files where you use their types.
Example: Having one source file doing networking does not make all files need an Import System.Net
And even then, you don't HAVE to import anything, you could also use the fully qualified name.
Eample: Dim form as System.Windows.Forms.Form would not require an Import System.Windows.Forms
In general I do not recommend you do this though.
So, if you have moved types to another namespace, watch the compiler error messages, and fix them, in the files the error messages point you to.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
I understand that you should not share every file.
Is there an easy way than going through and fixing each imports manually?
Humble Programmer
|
|
|
|
|
No. You fix the files the compiler complains about, there is no overall approach, if there were, it would to a large extent defeat the purpose of the namespace concept.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
I guess I was just hoping there would be something like the window where you can show unused references.
oh Well thank you for your time luc.
Brian
Humble Programmer
|
|
|
|
|
I believe there is a feature where you can tell Visual to remove unused imports. Which would be a file operation (so you order it for each source file, one by one), and not very valuable. I don't have any details about it, I've never used it.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
As far as the performance question, importing extra namespaces at the project level *may* affect the performance of the compiler *slightly*, but it will not affect the runtime performance of your program/library at all. By the time the IL is run, all calls are performed against fully resolved types/functions regardless of your imports.
|
|
|
|
|
I am trying to get the changes made to a datagrid to be saved back to the database.
Every time i update i get a concurrency error.
Any help would be greatly welcome.
Dave
Friend Sub UpdateDatabase()
frm.Cursor = Cursors.WaitCursor
Dim isGood As Boolean = True
If DataServer.IsConnLost Then
If DataServer.IsConnBack = False Then Exit Sub
DataServer.IsConnLost = False
End If
Dim sqlString As String = "SELECT * FROM " & frm.dgData.DataMember
Using conn As New SqlConnection(DataServer.SQLConn)
Using adapt As New SqlDataAdapter(sqlString, conn)
Using cmdbuilder As New SqlCommandBuilder(adapt)
adapt.TableMappings.Add("Table", frm.dgData.DataMember)
Try
adapt.Update(CType(frm.dgData.DataSource, DataSet).Tables(frm.dgData.DataMember).GetChanges)
Catch ex As Exception
WriteEventLog("Unknown EX " & Me.GetType.Name & vbCrLf & ex.Message & vbCrLf & ex.StackTrace, , EventLogEntryType.Error, , 58)
End Try
End Using
End Using
End Using
ChangeDataBase()
frm.Cursor = Cursors.Default
End Sub
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
