Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,148,810 members, 7,802,597 topics. Date: Friday, 19 April 2024 at 05:01 PM |
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 |