how to insert value in database using vb.net when i inserts one value it creates two rows in the table with same value

Question

0.00/5 (No votes)

See more:

VB

con.Open()
        If TextBox1.Text = "" And TextBox2.Text = "" Then
            MsgBox("Please Enter A Value", vbInformation)
        Else
            qur = "Insert Into EXA values('" + TextBox1.Text + "','" + TextBox2.Text + "')"
            Dim cmd = New OleDbCommand
            cmd = New OleDbCommand(qur, con)
            cmd.ExecuteNonQuery()
            dt = New DataTable()
            oAdapter = New OleDbDataAdapter(qur, con)
            oAdapter.Fill(dt)
            DataGridView1.DataSource = dt
            grid_dis()
        End If
        con.Close()

this is the code for inserting a value in oracle database
it have to inserts one value in databse but its inserts two values in database plzz help me

Posted 29-Sep-13 5:12am

vickeysanlge

Add a Solution

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)

OriginalGriff · Accepted Answer · 2013-09-29T05:21:00

Well, it could be that you are using the same INSERT query for your OleDbCommand.ExecuteNonQuery and for your OldDataAdapter.Fill - I'm pretty sure that if you replace data adapter command with a SELECT query, things will work rather better... :laugh:

BTW: Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead - it's a lot, lot safer!

"will you explain how to use parametrized queries plzzz...."

I will ignore the "replay fast" instruction - this one time, and one time only. Any future usages will get you no further response from me. It is rude, arrogant and unnecessary, and all it will do is annoy people. Please consider the possible effects of what you are about to say before you send or post a message!

VB

Using con As New SqlConnection(strConnect)
	con.Open()
	Using com As New SqlCommand("INSERT INTO EXA (myColumn1, myColumn2) VALUES (@C1, @C2)", con)
		com.Parameters.AddWithValue("@C1", TextBox1.Text)
		com.Parameters.AddWithValue("@C2", TextBox2.Text)
		com.ExecuteNonQuery()
	End Using
End Using

In addition, you should always list the columns you want to insert data into (I called them myColumn1 and myColumn2) - it helps prevent mistakes if the database is changed at a later date, and makes the code more readable. You can use any name for the parameters - I used C1 and C2 because I have no idea what the text boxes contain! (See what I mean about readability?)

And please, stop using Visual Studio default names for controls! Calling them "tbUserName" and "tbAddress" or whatever instead of "Textbox1" and "TextBox2" makes your code more readable, and it can be quicker to type because Intellisense can figure it out for you...