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?
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?
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?
Code:
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();
}