0

Hi

I am populating my combobox with table's data (example table name is "ITEMS" and table is having only one column and that is displayed as combobox items). In my form i am having i combobox,button and textbox. I will enter a new item in textbox and if i click on button, that new item will be stored in a table i.e. "ITEMS"). my problem is that new item has to be displayed in combobox items without closing my form and again opening it.
If i click button by entering new item in textbox that value has to be stored in table and combobox has to be populated with new item.

Thanks

5
Contributors
6
Replies
11
Views
8 Years
Discussion Span
Last Post by 03hasnam
0

When you "open" the form, include as part of the calling to open method an update of your combobox items.

0

Yo dude, you can always just refresh the connection, you don't need to close your form,

i take it you want something like this

using System.Data.SqlClient;


namespace TestDummyTWO
{
    public partial class Form1 : Form
    {
        SqlConnection sqlcon =
            new SqlConnection("Data Source=.;Initial Catalog=your_table;Integrated Security=True;Asynchronous Processing = True");

        SqlCommand sqlCom = new SqlCommand("SELECT ITEMS FROM YOUR_TABLENAME");

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            SqlDataReader reader = sqlCom .ExecuteReader();

            // Looping throuhg the list of data
            while (reader.Read())
            {
                // Fill combo Box with data
                comboBox1.Items.Add(reader["ITEMS"]);
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            // you added the new item from the tex box into the DATA TABLE
            // Not the combobox
            // use sqlCom again to do so

            sqlCom.CommandText = "Insert into blah blah";

            /* THIS IS WHAT YOU HAVE TO DO */
            sqlcon.Close();
            sqlcon.Open();
        }

Hope that helps ...

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.