Add data from a list box into SQL Server 2000 DB

Question

2.00/5 (1 vote)

See more:

Please anyone can help me out in adding the listbox items into a database table, i used the following code for doing so but it dosent work properly.. (it's a C# windows application)

using System;
using System.Collections.Generic;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

namespace test
{
public partial class MainForm : Form
{
  public MainForm()
  {
      InitializeComponent();
  }

  void Button1Click(object sender, EventArgs e)
  {
     SqlConnection conn = new SqlConnection(@"User ID=username; Password=pass; 
                    Initial Catalog=databasename; data source=localhost");
     SqlCommand cmd = conn.CreateCommand();
     foreach(object i in listBox1.SelectedItems)
     {
       cmd.CommandText = "INSERT INTO TableName (columnName) VALUES('"+i.ToString()+"')";
       cmd.ExecuteNonQuery();
     }
     conn.Close();
  }
}

Pls can any one help me out as soon as possible......

Posted 17-Mar-10 1:53am

Mahera 2

Updated 26-Mar-10 21:29pm

Sandeep Mewara

v4

Add a Solution

3 solutions

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)

Christian Graus · Accepted Answer · 2010-03-17T02:06:00

Solution 1

Well, what have you tried ? Which of the thousands of online articles on this have you read ? Which of the hundreds of books printed have you read ? How have you tried to do this for yourself before asking us to do it for you ?

Posted 17-Mar-10 2:06am

Christian Graus

**PSK_** · Accepted Answer · 2010-03-26T20:38:00

Approach you are following is not good, but still by doing as following your code will work.

foreach(ListItem i in listBox1.SelectedItem)
           {
               cmd.CommandText = "INSERT INTO TableName (columnName) VALUES('"+i.Text)+"')";
               cmd.ExecuteNonQuery();
           }

You can use either i.Text or i.Value as per your requirement.

You should have been done this as following.

Create a XML document for all the items and pass the xml to the DB, so that you can insert all the items in a single datbase trip.

tanukochhar · Accepted Answer · 2010-03-26T20:14:00

SqlConnection mycn;
SqlDataAdapter myda;
DataSet ds;
String strConn;
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
strConn="Data Source=localhost;uid=sa;pwd=;Initial Catalog=database";
mycn = new SqlConnection(strConn);
myda = new SqlDataAdapter ("Select * FROM Table ", mycn);
ds = new DataSet();
myda.Fill (ds,"Table");
DropDownList1.DataSource =ds.Tables [0] ;
DropDownList1.DataTextField =ds.Tables[0].Columns["Name"].ColumnName.ToString();
DropDownList1.DataValueField =ds.Tables[0].Columns["Id"].ColumnName.ToString();
DropDownList1.DataBind () ;

}
}

I m giving the code for select check this and try to insert the record .. Hope this will help you.
Good Luck

Add data from a list box into SQL Server 2000 DB

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0