How to use SQl statement in SQL CE

• k.subodh1

  Old Hand

  Points: 326

  More actions

  June 15, 2008 at 11:38 pm

  #71440

  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

• Sreejith P S

  Valued Member

  Points: 72

  More actions

  December 17, 2008 at 11:19 am

  #914059

  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