How to save ITEMS on listbox to MySQL Database in vb.net....
plz reply...
x2fair
-2
Light Poster
Recommended Answers
Jump to PostUsing Insert (SQL) statement.
Jump to Post... _cmd=new MySqlCommand(); ... _cmd.CommandText="insert into table Test values(?col1,?col2,?col3,?col4,?col5)" _cmd.Parameters.AddWithValue("?col1", listbox1.items(0)) _cmd.Parameters.AddWithValue("?col2", listbox1.items(1)) _cmd.Parameters.AddWithValue("?col3", listbox1.items(2)) _cmd.Parameters.AddWithValue("?col4", listbox1.items(3)) _cmd.Parameters.AddWithValue("?col5", listbox1.items(4)) ...
Jump to Postmy_cmd.CommandText = "insert into documenttable values(?route1,?route2,?route3,?route4,?route5,?route6,?route7,?route8,?route9,?route10,?route11,?route12)"
All 10 Replies
kvprajapati
1,826
Posting Genius
Team Colleague
x2fair
-2
Light Poster
kvprajapati
1,826
Posting Genius
Team Colleague
x2fair
-2
Light Poster
kvprajapati
1,826
Posting Genius
Team Colleague
x2fair
-2
Light Poster
kvprajapati
1,826
Posting Genius
Team Colleague
x2fair
-2
Light Poster
kvprajapati
1,826
Posting Genius
Team Colleague
x2fair
-2
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.