how do i insert listbox values into database

Question

0.00/5 (No votes)

See more:

I want to insert contents of the listbox into my database. the code am using is shown below. it doesnt seem to work. kindly help me out

for (i = 0; i <= addedroles.Items.Count; i++)
     {
      sql = "insert into roles(dept_id, role) values('" + id + "', '" + addedroles.Items[i] + "')";
     
      SqlCommand insert = new SqlCommand(sql, conn);
      cmd.ExecuteNonQuery();
      }

Posted 17-Jan-11 2:03am

Member 7250221

Add a Solution

3 solutions

Solution 2

What about setting a breakpoint at

SqlCommand insert = new SqlCommand(sql, conn);

and try to execute the sql statement in sql management studio?

It will hopefully tell you something about what's going wrong ...

Hiren is also on to something - you probably want check that the element type has a ToString() override returning the required text, or cast to the element type and access the correct property directly.

Regards
Espen Harlinn

Posted 17-Jan-11 2:09am

Espen Harlinn

Updated 17-Jan-11 2:15am

v2

Comments

Dalek Dave 17-Jan-11 10:40am

Good Call

Espen Harlinn 17-Jan-11 10:59am

Thanks Dalek!

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kyrielia · Accepted Answer · 2011-01-17T04:34:00

Solution 3

You seem to have to created an SqlCommand called 'insert', but then called 'cmd.ExecuteNonQuery()' to try and get the command to work.

However in the code snippet you've provided, 'cmd' doesn't exist.

Maybe try calling 'insert.ExecuteNonQuery()' instead?

Posted 17-Jan-11 4:34am

Kyrielia

Comments

Dalek Dave 17-Jan-11 10:40am

Well spotted.

Hiren solanki · Accepted Answer · 2011-01-17T02:06:00

Solution 1

Try it by foreach loop, Like

C#

foreach (ListItem item in lb.Items)
        {
            string Text = item.Text;
            string Value = item.Value;
        }

And prepare your query accordingly. And let us know if you're facing any error regarding.

Posted 17-Jan-11 2:06am

Hiren solanki

Comments

[no name] 17-Jan-11 8:45am

do i need to declare the ListItem name?

Manfred Rudolf Bihy 19-Jan-11 16:18pm

Wow got an accepted answer voted down! I had that happen to me before also and thought to myself WTF! 5+