C++/CLI OleDbException Error

[colintis]

Hi guys,

I'm having a System.Data.OleDb.OleDbException error with C++/CLI language environment. I've created a form with a DataGridView to show the whole table from the database, it is allowed to modify the records from the DataGridView. Once a button is pressed it will start the code below

conn->Open();
 
//Get changed rows if existed
dsChange = dsFac->GetChanges(DataRowState::Modified);
dsAdd = dsFac->GetChanges(DataRowState::Added);
dsDelete = dsFac->GetChanges(DataRowState::Deleted);
 
da = daFac;
strTable = "Facility";
 
if(dsChange)
{
    strSQL = "UPDATE Facility "
             "SET FName = @FName, FDescription = @FDescription "
             "WHERE FID = @FID";
    cmd = gcnew OleDbCommand(strSQL,conn);
    cmd->Parameters->Add("@FID", OleDbType::Char, 5, "FID");
    cmd->Parameters->Add("@FName", OleDbType::VarChar, 15, "FName");
    cmd->Parameters->Add("@FDescription", OleDbType::VarChar, 40, "FDescription");
    da->UpdateCommand = cmd;
    da->Update(dsChange, strTable);
}
if(dsAdd)
{
    strSQL = "INSERT INTO Facility (FID, FName, FDescription) "
             "VALUES (@FID, @FName, @FDescription)";
    cmd = gcnew OleDbCommand(strSQL,conn);
    cmd->Parameters->Add("@FID", OleDbType::Char, 5, "FID");
    cmd->Parameters->Add("@FName", OleDbType::VarChar, 15, "FName");
    cmd->Parameters->Add("@FDescription", OleDbType::VarChar, 40, "FDescription");
    da->InsertCommand = cmd;
    da->Update(dsAdd, strTable);
}
if(dsDelete)
{
    strSQL = "DELETE FROM Facility WHERE FID = @FID";
    cmd = gcnew OleDbCommand(strSQL,conn);
    cmd->Parameters->Add("@FID", OleDbType::Char, 5, "FID");
    da->DeleteCommand = cmd;
    da->Update(dsDelete, strTable);
}

The code above will detect the Modified, Added, Deleted actions made from the user. For example I'm updating one of the FDescription field in the records, pressed the button and it shows an error pointing to this line.

da->Update(dsChange, strTable);

Where the error message is:
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: No value given for one or more required parameter

This is the stack captured for the error..

     System.Data.dll!System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(System.Data.Common.RowUpdatedEventArgs rowUpdatedEvent, System.Data.Common.DbDataAdapter.BatchCommandInfo[] batchCommands, int commandCount) + 0x18b bytes    
     System.Data.dll!System.Data.Common.DbDataAdapter.UpdatedRowStatus(System.Data.Common.RowUpdatedEventArgs rowUpdatedEvent, System.Data.Common.DbDataAdapter.BatchCommandInfo[] batchCommands, int commandCount) + 0x2e bytes    
     System.Data.dll!System.Data.Common.DbDataAdapter.Update(System.Data.DataRow[] dataRows, System.Data.Common.DataTableMapping tableMapping) + 0x7d2 bytes    
     System.Data.dll!System.Data.Common.DbDataAdapter.UpdateFromDataTable(System.Data.DataTable dataTable, System.Data.Common.DataTableMapping tableMapping) + 0x2a bytes    
     System.Data.dll!System.Data.Common.DbDataAdapter.Update(System.Data.DataSet dataSet, string srcTable) + 0xb1 bytes    
>    WWZ_Admin.exe!WWZ_Admin::WWZ_DB::btnUpdate_Click(System::Object^ sender, System::EventArgs^ e) Line 372 + 0x11 bytes    C++
 

Can anyone tell me what am I missing on the dataset settings? or is it an error in another part? Any help is greatly appreciated.