Hello! I'm a newb, especially to databases, so bear with me. I'm writing a program which, ultimately, takes the value of textboxes and writes them to the database. The code to accomplish this is below. However, the changes don't seem to appear in the combobox (which contains all of the entries for a specific column of data) until after the application is restarted. Why is this? Thank-you in advance.

-----------------------------
        private void btnSave_Click(object sender, EventArgs e)
        {
            //Put textbox values into variables
            string txtMakeValue = txtMake.Text;
            string txtModelValue = txtModel.Text;
            int txtYearValue = Convert.ToInt32(txtYear.Text);
            double txtMileageValue = Convert.ToDouble(txtCurrentMileage.Text);

            //Create new row and fill in data
            VehiclesDataSet.CarsRow newCarsRow = vehiclesDataSet1.Cars.NewCarsRow();
            newCarsRow.Make = txtMakeValue;
            newCarsRow.Model = txtModelValue;
            newCarsRow.Year = txtYearValue;
            newCarsRow.Mileage = txtMileageValue;

            //Add new row
            vehiclesDataSet1.Cars.Rows.Add(newCarsRow);
            carsTableAdapter1.Update(newCarsRow);
        }

Computers will never surpass the human brain; no computer will ever be able to replicate human stupidity.

__________________
If only computers could write programs themselves...

Here are some suggestions
Try calling the AcceptChanges method of the dataset

vehiclesDataSet1.Cars.Rows.Add(newCarsRow);
vehicleDataSet1.Cars.AcceptChanges();
(Dont know if u would need to call the carsTableAdapter1.Update(newCarsRow); manually in that case).

Lemme know if this helps


Sreeram

With or without the Update method, I still need to restart the application to have the changes reflected in the combobox. However, I appreciate your help! Please give me any ideas you have!

Computers will never surpass the human brain; no computer will ever be able to replicate human stupidity.

Set DataSource and bind your dropdown again after this operation...

Sorry, I'm new. I used the Property window to set these options originally. Could you give an example of how to do this in code? My guess was to add

            this.cbxCurrentVehicle.DataSource = this.carsBindingSource;
            this.cbxCurrentVehicle.DisplayMember = "Model";
            this.cbxCurrentVehicle.ValueMember = "CarID";

but that doesn't seem to work.

Computers will never surpass the human brain; no computer will ever be able to replicate human stupidity.

Actually, never mind, I was playing around and got it! Here is what works. I used the AcceptChanges(); method, as well as:

                this.carsTableAdapter1.Fill(this.vehiclesDataSet1. Cars);
                this.cbxCurrentVehicle.DataSource = this.carsBindingSource;
                this.cbxCurrentVehicle.DisplayMember = "Model";
                this.cbxCurrentVehicle.ValueMember = "CarID";

Thank-you so much everyone! Your help is greatly appreciated. I will be back once I am more experienced to help others!

Computers will never surpass the human brain; no computer will ever be able to replicate human stupidity.