ASP.NET

Data inserting problem

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2008

Posts: 38

Reputation: preethi_ga is an unknown quantity at this point

Solved Threads: 0

preethi_ga preethi_ga is offline

Offline

Light Poster

Data inserting problem

Jul 20th, 2008

Hi ,
In the Insert button i have used the follwing coding,

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
 cmd = New OleDb.OleDbCommand("insert into emp values( ' " & TextBox1.Text & " ' , " & TextBox2.Text & "
 
 cmd = New OleDb.OleDbCommand("insert into emp values( ' " & TextBox1.Text & " ' , " & TextBox2.Text & "

Textbox 1 has String and Textbox 2 has Numeric data.

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
 con.Open() 
 cmd.ExecuteNonQuery
 con.Open() 
 cmd.ExecuteNonQuery

Connection string "con" declared Globally.
By executing the code i got error like, "OleDb Exception was UnHandled by the user code"
" Line 1: Incorrect syntax Error "

After that i changed the code,

 Help with Code Tags 
 asp Syntax (Toggle Plain Text) 
 Dim Ssql as String = "insert into emp(nam,regno)values(@nam,@regno)" 
 cmd = New SqlCommand(Ssql,con) 
 Dim Op1,Op2 as SqlParameter 
 Op1 = cmd.Parameter("@nam",SqlDbType.Char)) 
 Op2 = cmd.Parameter("@regno",SqlDbType.Char)) 
 Op1.Direction = ParameterDirection.Input
 Dim Ssql as String = "insert into emp(nam,regno)values(@nam,@regno)" 
 cmd = New SqlCommand(Ssql,con) 
 Dim Op1,Op2 as SqlParameter 
 Op1 = cmd.Parameter("@nam",SqlDbType.Char)) 
 Op2 = cmd.Parameter("@regno",SqlDbType.Char)) 
 Op1.Direction = ParameterDirection.Input

Like wise for Op2 also.

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
 Op1.Value = TextBox1.Text 
 Op2.Value = Textbox2.Text 
 cmd.ExecuteNonQuery
 Op1.Value = TextBox1.Text 
 Op2.Value = Textbox2.Text 
 cmd.ExecuteNonQuery

So by executing the above code, there is no error but same data's are inserted again and again, like if the textbox1 = preethi, textbox2 = 2001 are the data alredy present. then if i
clear those data by the "ADDNEW button" and if i insert new data , the new data are not stored, again that preethi and 2001 are stored.
i donno what will be the mistake..........!

Last edited by peter_budo; Jul 20th, 2008 at 11:08 am. Reason: Corecting tags, [code=asp.net]YOUR CODE HERE[/code]