[mono-vb] GridView/Npgsql, sorting & paging does not work

[Johannes Drachenfels]

Hi,

 

i am develop a asp application for hybrid use on Linux and Microsoft. My
application can use both - from both platforms...

 

My problem is now that when I use the GridView control, paging and
sorting works fine with MSSQL but not with Postgres. Same with
DataGrid... 

 

Is there maybe someone out who has experience with this?!

 

 

I use the following controls:

 

In web.config:

  <system.data>

    <DbProviderFactories>

      <add name="postgres"

      invariant="Npgsql"

      description=".Net Framework Data Provider for PostgreSQL"

      type="Npgsql.NpgsqlFactory, Npgsql, Version=1.99.2.0,
Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />

      <!-- other provider entries elided -->

    </DbProviderFactories>

  </system.data>

 

In form.aspx:

 

<asp:SqlDataSource ID="SDS" runat="server"></asp:SqlDataSource>

 

In source code:

 

'GV.DataSourceID = "SDS"

SDS.ConnectionString =
"Server=192.168.64.130;port=5433;Database=archive;Userid=archive;Passwor
d=ArcEmail;Protocol=3;SSL=true;Pooling=true;MinPoolSize=3;MaxPoolSize=20
;Encoding=UNICODE;Timeout=20;SslMode=Require;"

SDS.ProviderName = "Npgsql"

SDS.SelectCommand = "Select * from mailboxes"

SDS.DataBind()

 

 

Thanks for help & Regards,

 

Johannes

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-vb/attachments/20081020/f77e96b7/attachment-0001.html