ok the runtime error is :
OleDbCommand.Prepare method requires all parameters to have an explicitly set type.
The Trace stack:
[InvalidOperationException: OleDbCommand.Prepare method requires all parameters to have an explicitly set type.]
System.Data.OleDb.OleDbParameter.Prepare(OleDbCommand cmd)
System.Data.OleDb.OleDbCommand.PrepareCommandText(Int32 expectedExecutionCount)
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
System.Data.Common.CommandBuilder.BuildCache(Boolean closeConnection)
System.Data.Common.CommandBuilder.GetInsertCommand()
System.Data.OleDb.OleDbCommandBuilder.GetInsertCommand()
OakLeaf.MM.Main.Data.mmDataAccessOleDb.CreateInsertCommand()
OakLeaf.MM.Main.Data.mmDataAccessOleDb.SaveDataSet(DataSet ds, String tableName, String primaryKeyName, Boolean retrieveAutoIncrementPK, IDbDataAdapter dbAdapter)
OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey, IDbDataAdapter dbAdapter)
OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey)
OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName)
OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds)
OakLeaf.MM.Main.Web.UI.mmBusinessWebPage.Save(mmBusinessObject bizObj, DataSet ds, String tableName)
SCI.WebApp.Web.UI.OrderEdit.btnSave_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\SCI System Web CSharp\OrderEdit.aspx.cs:110
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()
The Source file and code : OrderEdit.aspx.cs Line: 110
Line 108:DataSet dsOrder = (DataSet)Session["dsOrder"];
Line 109:
Line 110:if (this.Save(this.oOrder, dsOrder, this.oOrder.TableName) ==
Line 111: mmSaveDataResult.RulesPassed)
Line 112:{
I am using VS 2003 - do you know if the data adapter wizard in VS 2005 still has "issues" with OLE Db connections?
Thanks for you help and patience.