this.DataTableAdaper.Update(Dataset) does not work...

[Sl1ver]

i created the dataset's bindings and everything using visual studio 2008 and on a access database, not i want to be able to work on both access and sql.

im doing the update function to basically "post" my data to the db just so that i can use that data afterwards to do other functions to my other grid.

how can i add the row on BeforeRowLeave so that the data gets posted and bool value sets to true and my other function implements?

 DataSet ds = this.dsRole.GetChanges();
                if (ds != null)
                {
                    try
                    {
                        this.qx_RoleTableAdapter.Update(this.dsRole.qx_Role);
                    }
                    catch (OleDbException ex)
                    {
                        MessageBox.Show("Error" + ex.ToString());
                    }
                }
 
 
                roleEndEdit = true;
            }
 
 
            if (roleEndEdit == true)
            {
                insertRoleRights();
            }
 

the best of all is that it says it has invalid data, how is that possibleif i just add text to the fields that was assigned to text in access and converted the whole db to sql. Would i need to change the datatype in sql or not?