Ado .net entity data model with My Sql database [Solved] - .NET (Core and Framework) Discussion Boards

polomint30-Oct-09 6:56

30-Oct-09 6:56

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 Smile | :)

Thanks again...

Oh oh...
Signed Polomint.......

Re: Intrumented versions of applications?

Not Active30-Oct-09 12:01

Not Active

30-Oct-09 12:01

Have a look here[^] to start with.

I know the language. I've read a book. - _Madmatt

Re: Intrumented versions of applications?

polomint30-Oct-09 12:19

polomint

30-Oct-09 12:19

Thanks, I'll take a look now...

Yippee Kai Yai
Signed Polomint.......

How do i interface with a mouse?

basilmir30-Oct-09 6:22

basilmir

30-Oct-09 6:22

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.

Re: How do i interface with a mouse?

Eddy Vluggen2-Nov-09 2:38

Eddy Vluggen

2-Nov-09 2:38

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 Suspicious | :suss:

Re: How do i interface with a mouse?

basilmir2-Nov-09 11:10

basilmir

2-Nov-09 11:10

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.

Re: How do i interface with a mouse?

cjb1103-Nov-09 5:44

cjb110

3-Nov-09 5:44

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'.

Ado .net entity data model with My Sql database [Solved]

Ravi Mori29-Oct-09 23:22

Ravi Mori

29-Oct-09 23:22

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

posted images in ads

balaji.t29-Oct-09 20:11

balaji.t

29-Oct-09 20:11

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

Compiling erases DATA in Access DATABASE ?

Johnkokk29-Oct-09 8:36

Johnkokk

29-Oct-09 8:36

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

Re: Compiling erases DATA in Access DATABASE ?

Luc Pattyn29-Oct-09 8:45

Luc Pattyn

29-Oct-09 8:45

Johnkokk wrote:
Is this normal ?

No, unless you included code to that effect.

Confused | :confused:

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Re: Compiling erases DATA in Access DATABASE ?

Johnkokk29-Oct-09 8:54

Johnkokk

29-Oct-09 8:54

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.

Re: Compiling erases DATA in Access DATABASE ?

Henry Minute29-Oct-09 9:05

Henry Minute

29-Oct-09 9:05

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.”

Re: Compiling erases DATA in Access DATABASE ?

Luc Pattyn29-Oct-09 9:36

Luc Pattyn

29-Oct-09 9:36

That makes perfect sense.
Putting data files in a Visual Studio folder is something I like to avoid.

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Re: Compiling erases DATA in Access DATABASE ?

Henry Minute29-Oct-09 9:43

Henry Minute

29-Oct-09 9:43

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.

Re: Compiling erases DATA in Access DATABASE ?

Johnkokk30-Oct-09 7:29

Johnkokk

30-Oct-09 7:29

Yeap, that was it.The "Copy always" thing.
I knew it was not "normal".

Thanks people.

Printer Settings in .NET

SunnerRock29-Oct-09 5:08

SunnerRock

29-Oct-09 5:08

Is there a way to set the printer output bin in .NET? It seems to be missing from the settings.

voice record

sura94529-Oct-09 4:21

sura945

29-Oct-09 4:21

how can i code voice record with c# languge

Re: voice record

Eddy Vluggen29-Oct-09 4:55

Eddy Vluggen

29-Oct-09 4:55

sura945 wrote:
how can i code voice record with c# languge

By programming the required functions. You might want to start with doing some research. There's a component on CodeProject[^] that can record sound.

HTH Smile | :)

I are Troll Suspicious | :suss:

Strong Names

lalithavdpl29-Oct-09 2:21

lalithavdpl

29-Oct-09 2:21

hi i have an idea on strong names
but i want in detail that are there any disadvantages in using strong names in my application.
Can u briefly explain me the concept that will be more helpful for me
thank you

Re: Strong Names

Not Active29-Oct-09 3:39

Not Active

29-Oct-09 3:39

Here[^]

only two letters away from being an asset

How to call Menu click event on TextChanged event....

jvipuln28-Oct-09 13:17

jvipuln

28-Oct-09 13:17

Hi All,

How can I raise/mimic Menu click event from some other control's(TextBox) event(TextChanged).

Actually I want to see Menu rolldown on event of text change in TextBox.

Can anyone please help?

Thanks in Advance,
Vipul

Re: How to call Menu click event on TextChanged event....

Not Active28-Oct-09 14:40

Not Active

28-Oct-09 14:40

First identify the environment, Windows or Web?

only two letters away from being an asset

Re: How to call Menu click event on TextChanged event....

jvipuln29-Oct-09 7:14

jvipuln

29-Oct-09 7:14