Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to use SQl statement in SQL CE Expand / Collapse
Author
Message
Posted Sunday, June 15, 2008 11:38 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 11, 2008 1:11 AM
Points: 10, Visits: 34
Hi

I am using SQL sever CE 3.1. I have created database and some table in this.after making connection iI have to nsert data into table .and i want to display table data into my Listview as a userinterface

I have to use INSERT INTO ITEM VALUES( )
AND
SELECT * FROM ITEM.

but i dont know where to use this statement

I am using vc++ and OLE DB

I am also taking help from northwind sample.





thanx
Post #517364
Posted Wednesday, December 17, 2008 11:19 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 19, 2011 5:43 AM
Points: 2, Visits: 37
Actually in C#, there is one menu like "Connect To Database" in Tools menu. Using that window you can connect sdf file. Next time you will get Server Explorer window with data connections, in that window you can do this type of sql statements.

Regards,
Sreejith P S :)
Post #621493
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse