How to use SQl statement in SQL CE

  • k.subodh1

    SSC Veteran

    Points: 246

    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

    SSC Rookie

    Points: 42

    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 🙂

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply