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

Mon Oct 20 05:34:11 EDT 2008

Hi,

This isn't a vb-specific issue, so you'll be better off asking in a more
generic mailing list like mono-list instead mono-vb.

Rolf

From: mono-vb-bounces at lists.ximian.com
[mailto:mono-vb-bounces at lists.ximian.com] On Behalf Of Johannes Drachenfels
Sent: lunes, 20 de octubre de 2008 10:31
To: mono-vb at lists.ximian.com
Subject: [mono-vb] GridView/Npgsql, sorting & paging does not work

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;Password=Ar
cEmail;Protocol=3;SSL=true;Pooling=true;MinPoolSize=3;MaxPoolSize=20;Encodin
g=UNICODE;Timeout=20;SslMode=Require;"

SDS.ProviderName = "Npgsql"

SDS.SelectCommand = "Select * from mailboxes"

SDS.DataBind()

Thanks for help & Regards,

Johannes

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.173 / Virus Database: 270.8.1/1730 - Release Date: 19/10/2008
18:02

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