F
Frederic Villeneuve
Hi, I'm trying to connected to MS SQL Server 2000 (MSDE) with a
touchscreen computer using Windows CE .NET 4.1 but I always receive
this error : PlatformNotSupportedException. Here is a copy of my
code. The connection is successful with CE .NET 4.2 and the visual
studio emulator but with CE 4.1 the connection failed.
There is an update or something I can do to use this code with CE 4.1
?
Thanks
Frederic
Dim strConnectionString As String
strConnectionString = "Integrated Security=false;user
id=sa;password=toto;database=adptest;server=P3000;"
Dim myConnection As SqlConnection
myConnection = New SqlConnection(strConnectionString)
myConnection.Open()
Dim sqlCommand As System.Data.SqlClient.SqlCommand
Dim sqlDataAdapter As System.Data.SqlClient.SqlDataAdapter
Dim ds As System.Data.DataSet
ds = New DataSet
Dim strSQLQuery As String
strSQLQuery = "SELECT * FROM Table1"
sqlCommand = New SqlCommand(strSQLQuery, myConnection)
sqlDataAdapter = New SqlDataAdapter(sqlCommand)
sqlDataAdapter.MissingSchemaAction =
system.Data.MissingSchemaAction.AddWithKey
sqlDataAdapter.Fill(ds, "Table1")
Me.DataGrid1.DataSource = ds.Tables("Table1")
touchscreen computer using Windows CE .NET 4.1 but I always receive
this error : PlatformNotSupportedException. Here is a copy of my
code. The connection is successful with CE .NET 4.2 and the visual
studio emulator but with CE 4.1 the connection failed.
There is an update or something I can do to use this code with CE 4.1
?
Thanks
Frederic
Dim strConnectionString As String
strConnectionString = "Integrated Security=false;user
id=sa;password=toto;database=adptest;server=P3000;"
Dim myConnection As SqlConnection
myConnection = New SqlConnection(strConnectionString)
myConnection.Open()
Dim sqlCommand As System.Data.SqlClient.SqlCommand
Dim sqlDataAdapter As System.Data.SqlClient.SqlDataAdapter
Dim ds As System.Data.DataSet
ds = New DataSet
Dim strSQLQuery As String
strSQLQuery = "SELECT * FROM Table1"
sqlCommand = New SqlCommand(strSQLQuery, myConnection)
sqlDataAdapter = New SqlDataAdapter(sqlCommand)
sqlDataAdapter.MissingSchemaAction =
system.Data.MissingSchemaAction.AddWithKey
sqlDataAdapter.Fill(ds, "Table1")
Me.DataGrid1.DataSource = ds.Tables("Table1")