Urgent problem with PgSqlDataSource and ASP.NET

Urgent problem with PgSqlDataSource and ASP.NET

Postby alessandro.marozin » Wed 27 Jan 2016 15:19

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
alessandro.marozin
 
Posts: 1
Joined: Wed 27 Jan 2016 14:56

Re: Urgent problem with PgSqlDataSource and ASP.NET

Postby Pinturiccio » Thu 28 Jan 2016 14:49

We have answered you via e-mail.
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL