Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error with oleDbData Adapter Config Wizard
Message
De
01/09/2005 18:43:56
 
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
C# 1.1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01044862
Message ID:
01046062
Vues:
21
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.
David "Doc" Herbert
Source Consulting Inc.
email: dave@2sci.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform