Post reply

How to use SQl statement in SQL CE

  • 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

  • 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 🙂

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

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