|
Hi
i am developing an application which will run on Dolphin 6100 (A smart device running on windows CE 5.0).
this application is a windows CE 5.0 application, which will interact with SQL Server 2005 Express database(installed on database server accessible through wireless access pint) and do some stock updates.
I am currently working with VB 6.0 and do not have enough time to learn VB.NET . could any one please translate this little piece of VB 6.0 code into windows ce 5.0(visual studio 2005) code.
Dim cn As New ADODB.Connection
If cn.State = 1 Then cn.Close
cn.Open "connection string for SQL server 2005 express" ?????????
Dim rs As New ADODB.Recordset
If rs.State = 1 Then rs.Close
rs.Open "select field1,field2 from TStock", cn, 2, 3
rs![field1]=some thing
rs.update
rs.close
cn.close
Specially i need connection string to connect to SQL Server 2005 Express from my windows ce 5 based smart device.
thanks and regards.
|
|
|
|
|
Hi,
connection strings need a server name; WinCE isn't any different in that.
For details see here[^].
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
Hi
thanks for reply.
i tried many connection strings from http://www.connectionstrings.com/[^] but no results.
actually i a confused about
1- which class i should use
SqlCeConnection or System.Data.SqlClient.SqlConnection
my situation is
i have SQL server 2005 express installed on a PC and i want to access that database from my windows ce 5.0 device through wireless connection.
i tried many connection strings but no one is working.
could you please tell me how to connect or which connection string i need to use?????????
thanks and regards.
riz
|
|
|
|
|
I'm unfamiliar with WinCE.
Why don't you ask in the Database forum?
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
I have been testing something like this today:
This website says you can't do it this way:
http://www.wirelessdevnet.com/channels/pda/features/ado_ce.html[^]
ADOCE Specifications
The first thing you need to know about ADOCE is that it is a subset of ADO. This means there is only implementation of the Recordset and Field objects. No Command object, no Connection, no Error, no Property. It does, though, offer automatic two-way synchronization with the desktop, ANSI SQL support, and (generally) standard ADO compatibility. Armed with that information, let's see what we need to install to develop with ADOCE.
I am going back to reading a text file because I have that option ... 
|
|
|
|
|
hi All
Can any body help me?
I have like this DataTable in vb.net:
A | B | C
------------
DLL |1,2 | 2
------------
DLL |3,4 | 2
------------
How Can I merage this dataTable in vb.net to
distinct A and merage B and Count C
A | B | C
--------------
DLL |1,2,3,4 | 4
|
|
|
|
|
Probably the simplest way would be to create a Dictionary with field A as the keys and a class to hold the new row data (at least fields B and C, maybe A as well) as the values. Then you can iterate over all the current data and build the new rows in the Dictionary.
|
|
|
|
|
Hi everyone,
A quick question if i may? I have been looking for a while for a way of logging all activity in my application by the user. I believe it is called instrumentation but I may be wrong. This is mainly so that when a user finds a problem with the software then I am able to playback exactly what they did. This will also allow me to see how the application is used by different users.
Does anyone know a way to do this? Links to further reading or maybe even links to software that I could use to do this would be appreciated.. In the meantime, I shall keep looking
Thanks again...
Oh oh...
Signed Polomint.......
|
|
|
|
|
Have a look here[^] to start with.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Thanks, I'll take a look now...
Yippee Kai Yai
Signed Polomint.......
|
|
|
|
|
Hello,
I have a small situation. Not quite a developer yet, so i need a top-down view from someone with experience.
I have a windows 7 box, and two mice connected to it, both using the windows default driver. As you can imagine they both work as a "mouse".
What do i have to do, to "manage" the input of the second mouse to make it do something else, not just mousing around? Use it's movement to map to keys, and so on and so forth.
Thank you in advance.
|
|
|
|
|
samoila.mircea wrote: What do i have to do, to "manage" the input of the second mouse to make it do something else, not just mousing around? Use it's movement to map to keys, and so on and so forth.
Learn C and write your own driver. This ain't possible in .NET, AFAIK.
I are Troll 
|
|
|
|
|
If it were only one mouse, then you'd be using a mouse-hook. There's an example on that on Fourth mouse button[^]. I doubt that this technique will work with two mouses (especially if they're identical), but you might want to give it a try before diving deeper into the system.
The second alternative is to write a small application that communicates with the serial port. We got many samples on that on CodeProject, especially for .NET - the only drawback being that you're limited to mouses with an old 9 pins serial cable. In that case you'd be interpreting the signals coming from the serial port yourself, and these signals may vary per manufacturer, or even by product.
I have some c experience. Do you know any paid or free video tutorials on how to do this...
There aren't that much video's on driver-development, you'd best start off with the Windows Driver Kit. http://www.microsoft.com/whdc/Devtools/wdk/
What IDE does one use?
You'd best ask the guys in the C++ forum what they're using - last IDE that I used was Borland C++ Builder 5. That compiler is still freely available today, I believe.
A big thanks goes to Eddy Vluggen.
|
|
|
|
|
A pure guess this, but you might want take a look at the XNA/DirectX stuff.
I'm just thinking that it has more capability of reconizing multiple input devices.
tbh as the other replies have suggested the problem will be at the driver level, and the OS doesn't do/offer any distinction between connected 'mice'.
|
|
|
|
|
Hi friends..
I used entity data model with Microsoft Sql database since 6 months.
But today i use MySql database and generate model for that database.
I got error when i insert a record in a table which have relationships with two other tables.This table have unique rows based on those two related tables.So this table don't have any primary key..
I got the following error:
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ......."
The table in which i insert data have not any primary key..So is it the reason for that error??
Please reply..Please also provide some good links for MySql+EntityDataModel if anybody have..
modified on Saturday, October 31, 2009 7:44 AM
The table in which i insert data have not any primary key..that was the reason for that error..
modified on Saturday, October 31, 2009 7:56 AM
|
|
|
|
|
hi all ,
I have already developed a website which is a finance portal.In the home page I have showcased data related to markets ((similar to any finance portal).I have left some empty zones to fill it with ad images.I have a separate Ad management application where I will upload ad images(jpeg,gif,bmp etc) and store it in the DB table.The ad management accesses data from another database.I want to pick a sample Ad image and put it in the homepage in the zone already created in a dynamic manner(coding).I dont have any CMS like MOSS.Can anyone let me know how it can be done?
note:When i create a ad I specify in which page it must appear.In this case it is home page along with when it should appear etc.
Thanx in advance.
T.Balaji
T.Balaji
|
|
|
|
|
Ok here is the issue.
I make an application, that the user can store various data in a MS ACCESS DATABASE.
I make all the connections, etc. and everything works ok.
So i test run my application.I insert data to the database through my program.Everything works ok.
I want to fix a bug.I correct the program and re run the app.
The database is empty now and i have to re-enter the data.
Even the slightest change in the program code, deletes the data from the database.
Is this normal ?
Thanks
|
|
|
|
|
Johnkokk wrote: Is this normal ?
No, unless you included code to that effect.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
Note that when i test run my app, i do it through the IDE.
Here are the steps, so that you can understand better.
1.Write some VB. net code.
2.Run through IDE
3.Insert data to database through my app
4.Find a bug
5.Stop the execution
6.Correct the bug
7.Re run the app through the IDE
Data that i inserted on step 3, are deleted and Database is empty.
If i open the database with MS ACCESS, fill some data there and run it from my app, everything is OK.
|
|
|
|
|
In Solution Explorer Window click your database file node (the one with the little golden cylinder icon) then hit F4.
Is 'Copy To Output Directory' set to 'Copy Always' (I think this is the default). If so, change it to 'Copy if Newer' or 'Never' once you understand what they mean.
I have been caught by this when I first started. What happens by default is that each time you run the app VS copies your empty database to your output directory, overwriting your nice data filled one.
'Copy if Newer' only does so if you change the DB in some way, so you need to take steps to protect the data you have entered.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
That makes perfect sense.
Putting data files in a Visual Studio folder is something I like to avoid.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
Yep.
Unfortunately, a couple of the MSDN HOWTO:s/WALKTHROUGH:s tell you to do it that way. Project|Add Item|Database.........
It usually mentions (or links to a page that does) the 'Copy Always' problem but it is well hidden.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Yeap, that was it.The "Copy always" thing.
I knew it was not "normal".
Thanks people.
|
|
|
|
|
Is there a way to set the printer output bin in .NET? It seems to be missing from the settings.
|
|
|
|
|
how can i code voice record with c# languge
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
