I have created a database using SQlServer CE with the name of db.sdf using the following code.[code]But i dont know where it keeps this emp.sdf file and how to view this. I have just started working on VB.NET Pocket PC application today and i am very confuse because my VB.NET connection code is not working as well with Pocket PC application.
View 2 Repliesi am creating an ppc application
I need to create an Order Entry System, which enables the sales executive to take order from the customers and feed them into there phones, and at the end of the day those phones will be connected to the desktop pc and all the orders should be synchronized with the desktop application.
DataBase part, i.e what should i use to save the data in the phone (i.e xml, db or anything else) and how should i synchronize it with the desktop software
Is it possible to use microsoft access database for Windows mobile application and save this mdb file locally in the pocket pc?because im trying to make an application to connect to mdb database but this imports seems to be not working.
HTML
Imports System.Data.oledb
oledb is not a member of system.data. why?
Is there a way to display the connection properties dialog for connection string browsing(for database) in run time?
As I want the user to be able to connect to various database using the GUI.
After running the following sub (VS debugger), I try to detach the database in SSMS, but it shows the connection open still and won't let me detach. If I close program in debugger, the database shows no connections. I check the dataadapter's connection in the finally block and is shows closed. What gives
Private Function ClientMasterDBFiles(ByVal MasterClientDBConnection As String, ByVal DBName As String) As DataTable
[Code]...
i am using access database for my program. now i have connected to the database in MDI form of main exe, and ir also works, user can log in, it gets verified etc etc etc. now here is the problem, when i load a form from dll and try to use any sql query on that form, i get message, "database connection is not opened". so what i did was, i added the connect() (a function i designed to connect to database) in the load part of the dll's form, it made the trick, query's started to run, everything went fine, and when i reload the form i.e after closing the form, i load it again from MDI form, i get error, connection already open..
[Code]....
I copied the exe onto the sd card for the pocket pc, but it doesnt show up when i go into file viewer.
Whats the best way for me to run this program i made for the pocket pc?
I have code but this isnt really a question about my programming.
I need tutorials and info related to this, but im not sure what im really looking for.
View 2 RepliesI'm using a OleDB connection to a access database. I'm entering a row into the database to set some user preferences. What i need to get is get back the row ID of the row I just entered. I'm more familiar with PHP and with PHP I use use this entry
[Code]...
I'm developing a aplication to run in Windows Mobile 5 I was design the first form, but when I try run them in the VB emulator, only appear the PPC with the Operating System. In the emulator, how can I try the sotware????
View 2 RepliesI'm developing a aplication to run in Windows Mobile 5I was design the first form, but when I try run them in the VB emulator, only appear the PPC with the Operating System.
View 1 RepliesI was using visual studio to program and deploy an application to pocket pc for the past week when all of the sudden the deploy stopped working. What happens is that I right click to deploy >> the menu asking me if I want to deploy to a device or emulator comes up and I select a device. In the past I could see in the status bar all the files that were being sent and about a minute later it said that it was successful. Now, it says deploy successful after about 1 second and nothing is sent to the device.
View 4 RepliesI was using visual studio to program and deploy an application to pocket pc for the past week when all of the sudden the deploy stopped working. What happens is that I right click to deploy >> the menu asking me if I want to deploy to a device or emulator comes up and I select a device. In the past I could see in the status bar all the files that were being sent and about a minute later it said that it was successful.
View 5 RepliesI want to play all sound formats in visual basic pocket pc.I'm using visual studio 2005 . net
View 2 RepliesI have created an PPC application which inputs some data from the user and creates an XML file. When the user connects the PPC to the PC i want to import the xml file and use that data. Update: Yes i know there is an seperate Mobile Development Section on this forum, but there is no population over there
View 3 Repliesi want to make a tetris like game in my pocket pc 2003, and im using Visual Studio 2005?
View 1 RepliesHow To Open A Camera Of The Pc-pocket On The Click Of The Button In Vb Net.
View 1 Repliesi looking for a way to read and write values in registry pocket pc using vb.net so far i have this:
[Code]...
Run VB 2008 Express Edition program on PDA / Pocket PC
View 1 Replieswhere can i find this application,i search the www.google.com to find this but i cant see this application i want to have a program in my pocket pc.
View 1 RepliesIs there a way to get the base folder of the executable? I tried some other things that I found on google, but I can't use them (not in the library or something like that).
View 4 RepliesI am trying to copy a table in a database into another database on another connection in VB.NET, using OleDb. If they were on the same connection I would just use SELECT INTO, but they are not. I have two different OleDbConnection and cannot see an easy way to do this.
Right now I am attempting to just copy the database into a DataTable using an OleDbDataAdapter, and then loop through the DataTable and insert every record into the target database one at a time. This obviously takes a ton of time for the large DB I could potentially be dealing with, and I have to deal with escaping strings, null values, etc.
edit - just to make this more clear: I have two OleDbConnection objects, one is linked directly to a local .mdb file on my computer (JET). The other is linked to a database on our servers (SQLOLEDB). I am wanting to do this:
"SELECT * FROM fromDB INTO toDB"
But I can't because fromDB and toDB are on different connections, and the OleDbCommand object is only attached to one. The only way I can see how to do this is to connect to fromDB, copy it into a DataTable, connect to toDB, and copy all of the data in the DataTable row by row into toDB. I was wondering if there is an easier way to do this.
I'm building an application for run in PPC. Is my first for this kind of equipment. At a time, I nedd to fill a datagrid, by one manual select. In VB forms it works perfectly, but I can't convert this for PPC forms. I use this
[Code]...
I'm having trouble figuring how to code the calculations for a Pocket PC application that calculates the cost of a cell phone bill. From a Pocket PC the user should enter the number of minutes used during the past month, in order to calculate the cost of the cell phone bill. The plan allows 300 minutes for $29.95 per month. For each minute over 300 the cost is $0.17 cents per minute. Tax and Fees are $4.85 a month.
1. User enters the number of minutes used during the past month.
2. Based on plan rate of 300 minutes for $29.95 and 17 cents for each minute over 300 calculate the cost of the bill including the fixed cost of $4.85.
3. The user must be able to initiate the calculation and display the individual charges and the total cost of the cell phone bill.
4. The user should be able to clear the number of cell phone minutes, the individual charges and the bill total
If negative number is enterd for the cell phone minutes, the user should be advised and asked for a valid entry If non numeric value entered for the cell phone minutes, or if left blank the user should be advised and asked for a valid entry.Application is deployed on the Pocket PC emulator built in VS 2008
Enter # of Minutes ________ (user enters)
Regular Minutes Charge ___ (29.95)
[code]....
I am trying to change my windows application I made in vb.net that uses an access database. I do not know where this database will be stored at this time so my plan is to set the connection using code based off a text file that points to the location of the database. Here is the code I have but I know there is something wrong with my syntax because it putting "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|IWS.mdb" in both the data source and the database name.[code]...
View 14 Repliesi am an IT student and i want to understand very well how to program in visual basic.net and how to manipulate its connection to database since my project uses visual basic environment.
View 1 RepliesI'm just learning VB and would like to know: How do I create VB connection to an Access 2007 DB? I can use the DataGridView to view the table but can not create a connection to add records.
View 3 Replieswith the meaning of this snippet?
string conString =@"Provider=Microsoft.JET.OLEDB.4.0;" + @"data source=c:illing.mdb"; OleDbConnection conn = new OleDbConnection(conString); Conn.Open(); DataSet ds = new DataSet(); OleDbDataAdapter adapter =
[code].....
I have a .mdf file that I open through an Open Dialog Box and use in a ConnectionStringBuilder (where I have the user instance set to True). Later, in one of my button clicks, I try to open the connection (connection.Open()). It then gives me an error as follows: "Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances."
Here is my code:
Option Strict On
Imports System.Data.SqlClient
Public Class frmMain
[code]....
I made program which connects sql database via WiFi network. I have timer wich every 10 minutes updates textbox information from database. If Network connection will be lose, i do not whant to get any error and after that lose data wich is in textbox, until sql database connection will not be. How can i check if connection exists and after that update data from database? Something like that:
Conn = New SqlConnection(ConnectionString)
Conn.Open() ' if connection is lost there gets error
If Conn.State = ConnectionState.Open Then ' But this does not works
[Code].....