VB.NET Compact Framework

25 May 2005 12:12 PM

Nilesh Patel via .NET 247

(Type your message here)

Hello Every one !

      I have an problem during the fill Dataadapter with DataSet & table name when it's running that time it's gving SqlCeServer.dll Error.

and i writen the code like this

Private Const pi_ConnPath As String = "\My Documents\JMS.sdf"
Private pi_WeightDetailsConn As System.Data.SqlServerCe.SqlCeConnection
Private pi_WeightDetailsAdapter As System.Data.SqlServerCe.SqlCeDataAdapter
Private pi_WeightDataSet As DataSet
Private pi_SQL As String

Dim WeightDetails As String

    pi_WeightDetailsConn = New SqlCeConnection("Data Source=" & pi_ConnPath)
    pi_WeightDetailsConn.Open()

    pi_SQL = "SELECT * from WeightMaster"
    pi_WeightDetailsAdapter = New SqlCeDataAdapter("pi_SQL", pi_WeightDetailsConn)

    pi_WeightDataSet = New DataSet

    pi_WeightDetailsAdapter.Fill(pi_WeightDataSet, "WeightDetails")
    DgWeightDetails.DataSource = pi_WeightDataSet.Tables("WeightDetails")
--------------------------------
From: Nilesh Patel

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>xpCVcOdF7k2iyvGshaLHCQ==</Id>

25 May 2005 1:03 PM

Ken Cox [Microsoft MVP]

Wrong group. Try here:

http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.pocketpc.developer&lang=en&cr=US

Show quoteHide quote

"Nilesh Patel via .NET 247" <anonym***@dotnet247.com> wrote in message
news:O40$WMSYFHA.4032@tk2msftngp13.phx.gbl...
> (Type your message here)
>
> Hello Every one !
>
>      I have an problem during the fill Dataadapter with DataSet & table
> name when it's running that time it's gving SqlCeServer.dll Error.
>
> and i writen the code like this
>
> Private Const pi_ConnPath As String = "\My Documents\JMS.sdf"
> Private pi_WeightDetailsConn As System.Data.SqlServerCe.SqlCeConnection
> Private pi_WeightDetailsAdapter As
> System.Data.SqlServerCe.SqlCeDataAdapter
> Private pi_WeightDataSet As DataSet
> Private pi_SQL As String
>
> Dim WeightDetails As String
>
>    pi_WeightDetailsConn = New SqlCeConnection("Data Source=" &
> pi_ConnPath)
>    pi_WeightDetailsConn.Open()
>
>    pi_SQL = "SELECT * from WeightMaster"
>    pi_WeightDetailsAdapter = New SqlCeDataAdapter("pi_SQL",
> pi_WeightDetailsConn)
>
>    pi_WeightDataSet = New DataSet
>
>    pi_WeightDetailsAdapter.Fill(pi_WeightDataSet, "WeightDetails")
>    DgWeightDetails.DataSource = pi_WeightDataSet.Tables("WeightDetails")
> --------------------------------
> From: Nilesh Patel
>
> -----------------------
> Posted by a user from .NET 247 (http://www.dotnet247.com/)
>
> <Id>xpCVcOdF7k2iyvGshaLHCQ==</Id>