TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
rulec444
NA
81
0
loop through items in a listbox and send to database
Jul 11 2004 12:12 PM
I'm trying to loop through items added to a listbox (in windows form) and send them to a table in a database. The user selects items from a listbox on the Left and clicks a button to add them to a listbox on the right. When they click a save button, I'm trying to loop through and get each item and send it to the database, but for some reason, I can't retreive each item from the listbox. This is my code: public void SendSelectedState() { foreach(Object i in lbxStateChosen.Items) { int c = 0; lbxStateChosen.SelectedItem = c; SqlParameter[] parameters = { new SqlParameter("@EntryValue", SqlDbType.VarChar) }; parameters[0].Value = lbxStateChosen.SelectedValue; try { SqlHelper.ExecuteNonQuery(cnDEV, CommandType.StoredProcedure, "gsp_State_Insert", parameters); } catch(Exception err) { MessageBox.Show(err + "error in sending filter to db"); } c++; }//end of foreach loop }//end of SendSelectedState() I receive an error that object reference is not set to an instance of an object - because I think its not recognizing the value of the selected item. Any suggestions?
Reply
Answers (
1
)
movable main window
Access the print-spooler