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( )
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.
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.
Sreejith P S 🙂
Viewing 2 posts - 1 through 1 (of 1 total)