Urgent problem with PgSqlDataSource and ASP.NET

[alessandro.marozin]

Hello,

I have a problem using an ASP.NET GridView connected to a PgSqlDataSource (I used Visual Studio designer for the configuration)
On UPDATE and DELETE queries with parameters the following exception is thrown (I used PgSqlMonitor for logging):

A first chance exception of type 'Devart.Data.PostgreSql.PgSqlException' occurred in Devart.Data.PostgreSql.dll
dotConnect for PostgreSQL: - Parameter name is missing.

PgSqlMonitor log the following query for example:

Prepare: UPDATE permissions
SET username = $1, password = $2, sha512password = $3, amcontrolpage = $4, amproductspage = $5,
amupgradespage = $6, amaccountspage = $7, amhistorypage = $8, note = $9
WHERE (permissionid = $10)

The stack trace shown on the browser is the following:

[PgSqlException (0x80004005): Parameter name is missing.]
Devart.Data.PostgreSql.PgSqlCommand.a(p[] A_0) +257
Devart.Data.PostgreSql.PgSqlCommand.InternalPrepare(Boolean implicitPrepare, Int32 startRecord, Int32 maxRecords) +1218
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) +838
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) +43
Devart.Data.PostgreSql.Web.c.ExecuteDbDataReader(CommandBehavior behavior) +69
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
Devart.Data.PostgreSql.PgSqlCommand.ExecuteReader(CommandBehavior behavior) +41
Devart.Data.PostgreSql.Web.c.ExecuteDbDataReader(CommandBehavior behavior) +172
System.Data.Common.DbCommand.ExecuteReader() +12
Devart.Common.DbCommandBase.ExecuteNonQuery() +58
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +378
System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +670
System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +87
System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +1210
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +738
System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +89
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +88
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +114
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +159
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724

I am using VS 2013 with .NET 4.5.1.
May be it is something trivial but I cannot find a solution. Any idea?

Thank you in advance.
Best regards

Alessandro

[Pinturiccio]

We have answered you via e-mail.

[hseifert]

I have the same problem.
What is the solution?

[Pinturiccio]

We have answered you via e-mail too.