accessing sql server data using vb.net for a pocket pc application?

heartplace83

hello everyone.. i really hope sumbody could help me on this..pls!! im currently doing my final year project and its due in 3 weeks! im doing a pocket pc application using vb.net and sql server.. the applictaion basically needs to connect to a databse to retrieve some data.. first of all, i chose the smart device applictaion to develop this..is this right? and is vb.net and sql server suitable for this.. secondly when i open a connection using codes like dim sqlconn as new sqlconnection...... the application seems to hang..why is this.. what should i do in the vb.net to connect to this sql server database.. do i write the codes or just simply go to project>connect databse..n its all done? im really a beginner in vbnet.. can anyone show me the codes for opening a connection to database and retrieving data from a table there?? please anyone,pls help me....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

heartplace8321y ago
erm okay thanx a lot ill check it out.. ;)
MythicalMe21y ago
If you're a final year student then you should already know to do this: Do a search of the MSDN site. There is an excellent white paper on the subject. I'll sum it here... There are 3 ways to approach this problem: Direct connect, queued, and SQL CE To use direct connect or the queued method you'll need to use VS Studio 2003. Direct connect is only useful when the pocket pc is assured to have a constant connection. Queued is the preferred method and is also the most difficult. Finally, if you have access to SQL Server CE then you connect to that server and update syncronize periodically. I've actually got a 4th solution, and that is to write ASP.Net applications and use the browser of the pocket PC. This way your data is always available and you're not trying to use up valuable resources on the Pocket PC.