search

ErikEJ / SqlCeToolbox

SQLite & SQL Server Compact Toolbox extension for Visual Studio, SSMS (and stand alone)
Other
847 stars 174 forks source link

The specified type is not supported by this selector #961

Closed drn57 closed 1 year ago

drn57 commented 1 year ago

Hi, I'm using Visual Studio 2022 to realize simple application for CRUD an sql compact database. I realized a database with 3 table and several fields inside. This is the database information.

-- Script Date: 17/05/2023 15:14 - ErikEJ.SqlCeScripting version 3.5.2.94 -- Database information: -- Locale Identifier: 1040 -- Encryption Mode: -- Case Sensitive: False -- Database: C:\Users\John\Desktop\Bart\bartDb.sdf -- ServerVersion: 4.0.8876.1 -- DatabaseSize: 128 KB -- SpaceAvailable: 3,999 GB -- Created: 17/05/2023 10:48

-- User Table information: -- Number of tables: 3 -- mixed: 0 row(s) -- proof: 0 row(s) -- testet: 0 row(s)

Database is connected but when I place a datagridview on the form the procedure to connect the data source after few steps ends as following..

imm

Any suggestion? Thanks a lot. Robin

ErikEJ commented 1 year ago

This usage is not supported with the "Simple" provider - you will have to use a code based approach with ObjectDataSource.

image

drn57 commented 1 year ago

Hi.. yes you are right... my mistake. many thanks

Cordiali Saluti / Kindest Regards Adriano Fusi

Il giorno gio 18 mag 2023 alle ore 09:29 Erik Ejlskov Jensen < @.***> ha scritto:

This usage is not supported with the "Simple" provider - you will have to use a code based approach with ObjectDataSource.

[image: image] https://user-images.githubusercontent.com/4169187/239170902-eb1b4611-6424-40bb-8db7-ea78e7dd55ae.png

— Reply to this email directly, view it on GitHub https://github.com/ErikEJ/SqlCeToolbox/issues/961#issuecomment-1552639869, or unsubscribe https://github.com/notifications/unsubscribe-auth/A75NUBNFV7TXA7AOQHSWG4LXGXFWPANCNFSM6AAAAAAYFDAKVE . You are receiving this because you authored the thread.Message ID: @.***>