[vadlak]

Hello,

I am new to the forums but I was refered here to get some help. My problem is that i have a list text box and a database and I know how to insert my data into it. Which works perfectly fine, But when I have no idea where to start to get the list box to show the data that was inputed.

Here is my Insert Code

     
private void button1_Click_1(object sender, EventArgs e)
        {
            Form1.lb.Items.Add(textBox1.Text + "" + textBox2.Text);
            string connectionstring = (@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");
            SqlConnection connection = new SqlConnection(connectionstring);

            string First = textBox1.Text;
            string Last = textBox2.Text;
            SqlCommand command = new SqlCommand();
            command.Connection = connection;

            command.CommandText = ("INSERT INTO [User] ([First Name],[Last Name]) VALUES (@First, @Last)");
            command.Parameters.AddWithValue("@First", First);
            command.Parameters.AddWithValue("@Last", Last);
            connection.Open();
            command.ExecuteNonQuery();
        }

This works fine.

So basically i have that you type in the text box and it inputs it into the database. But then i need, in Form 1 to automatically pull that information and make it an Item in the list. I have spent 2 hours already and have looked at tutorial around the web heck i even searched your site. Im new to Sql but not c#

[Searock]

So are the textbox and the listbox in the same form or are they in different forms ?

This post has been edited by Searock: 30 May 2010 - 08:26 AM

[Sergio Tapia]

private void button1_Click_1(object sender, EventArgs e)
        {
            Form1.lb.Items.Add(textBox1.Text + "" + textBox2.Text);
            string connectionstring = (@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");
            SqlConnection connection = new SqlConnection(connectionstring);

            string First = textBox1.Text;
            string Last = textBox2.Text;
            SqlCommand command = new SqlCommand();
            command.Connection = connection;

            command.CommandText = ("INSERT INTO [User] ([First Name],[Last Name]) VALUES (@First, @Last)");
            command.Parameters.AddWithValue("@First", First);
            command.Parameters.AddWithValue("@Last", Last);
            connection.Open();
            command.ExecuteNonQuery();
            //Add this method to update the listBox 'lb' after it saves the information.
            PopulateMyListBox();
        }
public void PopulateMyListBox()
{
    //Retrieve the dataset from the database.
    //Call the databind method on the listbox.
    lb.DataSource = YourDataSet;
    lb.DataBind();   
}

[vadlak]

That didnt work for me. It didnt find databind. So i used a datareader

 
            SqlCommand cmd = new SqlCommand("SELECT ID from [User]", connection);

            SqlDataReader rdr = null;
            // 2. Call Execute reader to get query results
            rdr = cmd.ExecuteReader();

            // print the CategoryName of each record
            while (rdr.Read())
            {
                Form1.lb.Items.Add(rdr[0]);
            }

The problem though is that it goes. 12 then if do it again i get 123 and then 1234 etc

This post has been edited by vadlak: 30 May 2010 - 01:28 PM