I don't understand why it doens't update my Access Database...

[fdsaasdf]

Hi everyone,

I don't understand why this doesn't update my actual MS Access 2003 mdb file. During debug phase, I learned that it updates the dataset and creates new rows. But it doesn't reflect into the database. Why is it so? Please help me out. Thanks in advance.

else
            {
                //Auto generate item code            
                txtIcode.Text = this.GenerateCode(ItemDS.Item, "ITM-");

                // Create a new row.
                CSOAIS.BACKEND.DATASETS.ItemDataset.ItemRow NewItemRow;
                NewItemRow = ItemDS.Item.NewItemRow();

                NewItemRow.ItemCode = this.GenerateCode(ItemDS.Item, "ITM-");
                NewItemRow.ItemName = this.txtIname.Text;
                NewItemRow.ItemDesc = this.txtIdesc.Text;
                NewItemRow.CategoryCode = (string)this.cmboCategory.Text;
                NewItemRow.SubCategoryCode = (string)this.cmboSubCat.Text;
                NewItemRow.UnitMeasureCode = (string)this.cmboUM.Text;

                //set default values
                NewItemRow.LocationCode = "CSO";
                NewItemRow.StatusCode = "Active";

                // Add the row to the Item table
                ItemDS.Item.Rows.Add(NewItemRow);

                // Save the new row to the database
                this.itemTableAdapter.Update(ItemDS.Item);
 
            }

[DdoubleD]

It looks like you are creating a new row, but you are calling Update (missing UpdateCommand though too for that): http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdataadapter.updatecommand(VS.71).aspx

For inserting a new row, you need to specifiy an InsertCommand: http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdataadapter.insertcommand(VS.71).aspx