Duplicate Record in the same time in sql database

Question

1.00/5 (1 vote)

See more:

This code i create it to insert Valus in sql Database but this Code insert Duplicate Record in the same time

I do not know why this Duplication

VB

connectionString = ConfigurationManager.ConnectionStrings("conString").ToString
con = New SqlConnection(connectionString)
con.Open()
cmd = New SqlCommand("INSERT INTO Msg (ID,MsgName,MgsPhone,MsgAdd,Msgmail,Msgcomm,msgdate,Msgtime,latitude,longitude)VALUES ( '" + Request.QueryString("ID") + "', '" & TxtName.Text & "', '" & TxtPhone.Text & "', '" & TxtAdd.Text & "', '" & TxtMail.Text & "' , '" & Txtcomm.Text & "' , '" & System.DateTime.Now.ToString((" yyyy-MM-dd")) & "','" & System.DateTime.Now.ToShortTimeString() & "', '" & latitude & "', '" & longitude & "')", con)
cmd.ExecuteNonQuery()
con.Close()
Response.Redirect(Request.Url.AbsolutePath + "?status=1", False)

Posted 22-Apr-13 21:57pm

hany1002

Add a Solution

Comments

Prasad Khandekar 23-Apr-13 4:02am

Insufficient information. Your page might be getting posted twice. Your table may not have a primary key.

hany1002 23-Apr-13 4:22am

First Column In my table

MsgID int Unchecked

vaibhav10Dec1987 23-Apr-13 4:54am

can you provide me in which event you wrote that code...

hany1002 23-Apr-13 4:55am

Protected Sub btnSave_Click(sender As Object, e As EventArgs) Handles btnSave.Click

hany1002 23-Apr-13 5:05am

i found the problem in this html line

<asp:Button ID="btnSave" runat="server" CssClass="bigButton2" style="color: #FFFFFF; font-weight: 700; background-color: #333333" Text="Send" Width="180px" Height="38px" onclick="btnSave_Click" />

in this code (onclick="btnSave_Click" />)

why this problem according ???

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

hany1002 · Accepted Answer · 2013-04-22T23:13:00

XML

i found the problem in this html line

         <asp:Button ID="btnSave" runat="server" CssClass="bigButton2" style="color: #FFFFFF; font-weight: 700; background-color: #333333" Text="Send" Width="180px" Height="38px" onclick="btnSave_Click" />


in this code  (onclick="btnSave_Click" />)