N
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")
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")