Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,148,810 members, 7,802,597 topics. Date: Friday, 19 April 2024 at 05:01 PM

Please Help Is Needed On How To Insert Two Or More Record Under A Single Field - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Please Help Is Needed On How To Insert Two Or More Record Under A Single Field (634 Views)

PHP Code To Insert And Retrieve Images From Mysql Server / How To Insert Data Into An Online Mysql Database In Java / How To Insert Pictures Or Images In Textedit (webdesign) (2) (3) (4)

(1) (Reply)

Please Help Is Needed On How To Insert Two Or More Record Under A Single Field by abdul24(m): 7:29pm On Apr 08, 2015
i try to insert 10 record under the field year and actual data but only the first text from text1 is entering inside
provider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source ="
dataFile = "db7exmpl.accdb"
connString = provider & dataFile
myConnection.ConnectionString = connString
myConnection.Open()
Dim str As String
'str = " INSERT INTO tb (Years) VALUES('" & TextBox1.Text & "," & TextBox3.Text & "," & TextBox5.Text & "');"
str = "insert into tb ([Years], [Actual_data]) values (?, ?)"
Dim cmd As OleDbCommand = New OleDbCommand(str, myConnection)

cmd.Parameters.Add(New OleDbParameter("Years", CType(TextBox1.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Years", CType(TextBox3.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Years", CType(TextBox5.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Years", CType(TextBox7.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Years", CType(TextBox9.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Years", CType(TextBox11.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Years", CType(TextBox13.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Years", CType(TextBox15.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Years", CType(TextBox17.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Years", CType(TextBox19.Text, String)))

cmd.Parameters.Add(New OleDbParameter("Actual_data", CType(TextBox2.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Actual_data", CType(TextBox4.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Actual_data", CType(TextBox6.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Actual_data", CType(TextBox8.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Actual_data", CType(TextBox10.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Actual_data", CType(TextBox12.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Actual_data", CType(TextBox14.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Actual_data", CType(TextBox16.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Actual_data", CType(TextBox18.Text, String)))
cmd.Parameters.Add(New OleDbParameter("Actual_data", CType(TextBox20.Text, String)))
Try
cmd.ExecuteNonQuery()
'myConnection.Close()
Catch ex As Exception
MsgBox(ex.Message)

End Try

(1) (Reply)

Who Else Wants To Know How To Build A Mobile Optmized Authority Website And.... / The Nickzom Empire / Which Is The Best??? Facebook, Twitter, Whatsapp?

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 10
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.