Member Avatar for nmakkena

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
  • 3K Views
  • 4 Years Discussion Span
  • Latest Post Latest Post by 03hasnam

Recommended Answers

All 6 Replies

Member Avatar for ddanbe

A form doesn't close by itself. Could you send your code with the eventhandler of the button?

Member Avatar for LizR

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

Member Avatar for cVz

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 ...

Member Avatar for nmakkena

Hi
Thanks alot. it worked for me

Member Avatar for cVz

Cooooollll

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.