C# Discussion Boards - CodeProject

Re: Problem: How to include DLL when I compiled my windows mobile project?

22-Jan-09 5:05

Hello all,

I have created a DLL (smart device -> win32 application -> DLL) in Visual Studio 2005 and it can be compiled successfully using the Windows Mobile 6 SDK.

I try going to test my DLL by creating a new project (c#->device application -> wm6 application) and add the DLL to it. I tried dragging the DLL into application it works, but it doesnt work when I tried to add reference to it However, whenever I try building the project on simulator, it says it cannot find the DLL.

Funny enough, when I directly put the application exe and the dll to my device, it works. But I observe that my DLL library is not performing what it should be.

What is the problem with it ? Assistance of any forms will be highly appreciated.

Thanks,

Leslie

Tony Richards22-Jan-09 5:07

Tony Richards

22-Jan-09 5:07

It sounds like the DLL isn't being copied over to the device when you are testing. What exactly do you mean by

leslie wu wrote:
I tried dragging the DLL into application it works, but it doesnt work when I tried to add reference to it

If there isn't a reference to the DLL in the project, I doubt VS will know to copy it over when testing.

Edit : Also, what sort of DLL is it (is it, for example, a .Net Assembly)?

My Blog: This Blog

Re: Problem: How to include DLL when I compiled my windows mobile project?

leslie wu22-Jan-09 5:40

Re: Problem: How to include DLL when I compiled my windows mobile project?

22-Jan-09 5:40

Hi Tony,

Thank you for your reply. What I mean by that is if I drag my compiled DLL from windows explorer directly into the the solution explorer space, I can see the DLL copied into the project.

However, if I try adding by clicking: my project -->"add reference" and add my DLL,it says " A reference to mydll could not be added.

What is the problem with it ? What should be the proper way in adding my DLL ?

And to my second problem concerning my dll function is not working properly, any clue ?

Thanks,

Leslie

leslie wu22-Jan-09 6:08

Re: Problem: How to include DLL when I compiled my windows mobile project?

22-Jan-09 6:08

To be precise, I got the following error:

An unhandled exception of type 'System.MissingMethodException' occurred in DeviceApplication2.exe

Additional information: Can't find PInvoke DLL 'smartdevicedll.dll'.

Ennis Ray Lynch, Jr.22-Jan-09 6:10

Ennis Ray Lynch, Jr.

22-Jan-09 6:10

That is a versioning error, usually.

Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.

If you don't ask questions the answers won't stand in your way.

Most of this sig is for Google, not ego.

Re: Problem: How to include DLL when I compiled my windows mobile project?

leslie wu22-Jan-09 6:36

22-Jan-09 6:36

Got it ...you need to use Window CE Remote File Viewer to look at the path..

Everything sorted..thanks everyone !!!

C# and SQL Project

Michael Fritzius22-Jan-09 4:22

22-Jan-09 4:22

Hi everybody,

I've got a potential customer that would like a C# GUI that interfaces with an SQL server somewhere. So, I'm trying to figure out where to start. Don't know a ton about SQL, but it looks like this guy is just wanting some basic INSERT and SELECT functions done on a table.

I took a look at this article http://www.codeproject.com/KB/database/sql_in_csharp.aspx[^] and see that it's a good start. However, I've got some questions that need to be addressed first:

1) No idea if this makes a difference, but if the SQL server is running behind a firewall or a router, how do I get to it? Is it something like inputting an IP address/port combination, username and password?

2) How can I get a server to test my program on locally that I have control of? I don't want to be using a (hopefully not) buggy program on someone else's server Smile | :)

Thanks for entertaining a complete noob about SQL.

Take care,

Michael Fritzius

led mike22-Jan-09 4:40

led mike

22-Jan-09 4:40

1) There are many options. Today the most notable is to place one or more web services behind the firewall and use them to interface with from the client.

2) I don't understand the question. How do you get a server?

led mike

Michael Fritzius22-Jan-09 4:52

22-Jan-09 4:52

led mike wrote:
2) I don't understand the question. How do you get a server?

I meant how to get an SQL server running someplace. Something with a database on it that I can run my program against to check and see that the correct info is being added/read at the server. What would you recommend?

EliottA22-Jan-09 5:01

EliottA

22-Jan-09 5:01

Install either MySQL server or MSSQL express, both are free and you won't have to worry about firewalls and what not. You can learn how to interact C# and SQL easily here.

Good luck!

led mike22-Jan-09 5:03

led mike

22-Jan-09 5:03

For testing any workstation can operate as a server for just about everything other than load/stress testing. In many cases I have everything running on my developer workstation for developing. Then things get installed in test labs for real testing.

You probably want to start digging into Security issues sooner rather than later.

led mike

Wendelius22-Jan-09 4:50

Wendelius

22-Jan-09 4:50

Michael Fritzius wrote:
if the SQL server is running behind a firewall or a router, how do I get to it? Is it something like inputting an IP address/port combination, username and password?

One way is to build a three-tiered application or if you want to do this like client-server, you would need (secure) ip-connection through the firewall. Connection string is exactly what you described: ip,port (or server name), username and password.

Michael Fritzius wrote:
How can I get a server to test my program on locally that I have control of? I don't want to be using a (hopefully not) buggy program on someone else's server

If you mean how would you get a database, you could use for example SQL Server Express Edition[^].

The need to optimize rises from a bad design.My articles[^]

Michael Fritzius23-Jan-09 4:26

23-Jan-09 4:26

Ok, so I'm trying to get SQL Express on my home machine. Already tried downloading and installing it on the work machine, but for whatever reason it didn't work. This is fine, because I don't really want to develop this project on the work PC anyway.

...and it looks like I might be over my head on this. Is SQL supposed to be this hard to install?

Has anyone been successful with getting some version of the server installed and functioning properly that would be willing to walk me through the process OR point me to a tutorial on how to do it?

Thanks muchly,
Michael Fritzius

Michael Fritzius26-Jan-09 3:57

26-Jan-09 3:57

Hi all, and thanks for all the help so far.

I've successfully gotten SQL Server 2008 running on my home machine, and can make databases, add rows/columns, everything I would need for this project.

Also, the program written to interface with the server at the local level works great.

Now I'm trying to log onto the same server and use the program to access the server remotely, from a computer on the same network, but having no success.

It gives me the following error: Login failed for user XXXX/Guest.

I know the info is getting to the server just fine, because of the nature of the error, and because I ran Wireshark to see if info was getting passed, and it was.

And, I've looked on Google and on here for a solution, but nothing seems to help.

I know that there needs to be a username/password on the SQL server itself so it knows if it can accept the incoming connection. Already tried this, but it didn't work, so I know I did something wrong... just don't know what.

If you know the answer, please help.

Thanks for all your suggestions so far and take care,
Michael Fritzius

GetDriveName in C#

mulugheta22-Jan-09 4:00

mulugheta

22-Jan-09 4:00

Hi Everybody

In VB6 we can call GetDriveName of FileSystemObject. But i don't know how it work with in c#.

Could you please help me?

THank you

Ben Fair22-Jan-09 4:04

Ben Fair

22-Jan-09 4:04

Use DriveInfo.GetDrives(), from the System.IO namespace.

Keep It Simple Stupid! (KISS)

mulugheta22-Jan-09 4:13

mulugheta

22-Jan-09 4:13

If you are look for lists of Drives you are right. But i am look for drive name from a give absolute path of a file.

Ben Fair22-Jan-09 4:34

Ben Fair

22-Jan-09 4:34

OK, in that case use Path.GetPathRoot(), also in the System.IO namespace.

Keep It Simple Stupid! (KISS)