C# Discussion Boards - CodeProject

Re: MySQL inserting UnicodeStr

pnpfriend13-Jul-07 9:30

pnpfriend

13-Jul-07 9:30

I am using 4.1.10a-nt-max
after I called Select Version();

excel is behaving strange

m@u13-Jul-07 6:44

m@u

13-Jul-07 6:44

Hello everyone

i'm not quite sure if this is the right forum for this.
in an application i'm writing, i try to create an excel sheet. the problem i have is when i try to set the left and center footers.

the Excel - Version I use for development is Excel 2002 but i use generated interop - assemblies from the Excel 2000 version.

i say:

<br />
ws.PageSetup.LeftFooter = "&14&N Seite(n)";<br />
ws.PageSetup.CenterFooter = "&14&F";<br />

ws is the worksheet.

anyway, in the page preview, the the left footer displays the filename instead of the pagecount and the center footer displays nothing at all

when i let excel generate macro code for the footers it says:

<br />
ws.PageSetup.LeftFooter = "&14&F Seite(n)"<br />
ws.PageSetup.CenterFooter = "&14&B"<br />

the workaround i found is telling Excel what i DON'T want in the Footers:

<br />
ws.PageSetup.LeftFooter = "&14&A Seite(n)";<br />
ws.PageSetup.CenterFooter = "&14&N";<br />

now it displays the correct information in the footer.

does anyone know where dis behaviour comes from?
i can generally live with it that way, i just curous about the why Smile | :)

greets
M@u

Re: excel is behaving strange

Paul Conrad13-Jul-07 11:59

Paul Conrad

13-Jul-07 11:59

Not sure why that's happening

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

writting error code in master page

daku113-Jul-07 6:26

daku1

13-Jul-07 6:26

i have created a error page and have abought 20 page want to write a code in my master page where every page is dervied from that page please can some one tell how to write a that code and what code /
thank you
sandip patel

How to get properties of flash files

monamour13-Jul-07 5:08

monamour

13-Jul-07 5:08

I wanna know how can I get the properties of flash (.swf , .fla) files within C# program.

Re: How to get properties of flash files

Giorgi Dalakishvili13-Jul-07 5:52

Giorgi Dalakishvili

13-Jul-07 5:52

Which properties? Specific to flash files?

#region signature
my articles
#endregion

DLLImport of old dll

HeiniBlad13-Jul-07 4:59

HeiniBlad

13-Jul-07 4:59

how would you import this dll into your c# project?
old c style exports in the dll.

<br />
DBRESULT  WINAPI dbLoginDataBase ( LPSTR lpDataBase, LPSTR lpDictionary, LPSTR lpUsername, LPSTR lpPassword )<br />
DBRESULT WINAPI dbReadSingleRecord  ( LPSTR ViewName, LPSTR DataBuffer, LPWORD lpDataBufLen,<br />
                                      LPSTR ParamBuffer, WORD ParamBufLen, RECPOS RecPos,<br />
                                      BOOL Lock, LPDBOID lpDboID )<br />
<br />
typedef void    *           LPDBOID;<br />
<br />

any ideas? anyone?
Thanks!

Re: DLLImport of old dll

kubben13-Jul-07 5:43

kubben

13-Jul-07 5:43

There are a couple of different ways you can do it.

Here is a link to an article I wrote where I call a dll:
http://www.codeproject.com/dotnet/windowsappsingleinstance.asp[^]

This article uses dllimport

Ben

Re: DLLImport of old dll

HeiniBlad13-Jul-07 8:42

HeiniBlad

13-Jul-07 8:42

my problem is to get the void * in there. and when to use ref and out.
i just can't figure this out on my own. call me newbie if you want. i just don't get it.

Re: DLLImport of old dll

mav.northwind13-Jul-07 9:11

mav.northwind

13-Jul-07 9:11

If you're unsure how to marshal a LPVOID, you could start with IntPtr...
The Marshal class also has methods to alloc and free unmanaged memory that can come in handy in this situation.

Regards,
mav

--
Black holes are the places where God divided by 0...

Re: DLLImport of old dll

kubben13-Jul-07 10:35

kubben

13-Jul-07 10:35

I would use the ref and pass in a IntPtr. I think that would work, but I guess you won't know until you try.

Ben

Re: DLLImport of old dll

Luc Pattyn13-Jul-07 11:30

Luc Pattyn

13-Jul-07 11:30

Hi,

you can watch how this P/Invoke site[^] calls a lot
of Win32 functions; you can compare their C arguments with yours and do the same
in your code. (Make sure to check a couple of similar cases, there may be some mistakes !)

In general, if C needs an address pass a value type by reference ("ref"), or a
reference type as is (e.g. a const char* arg in C is a string in C#).
If C needs an address of an address (not often) pass a reference to a reference type.
If native code needs to write to a string argument, pass it a StringBuilder with sufficient
Capacity.

etc etc etc

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: DLLImport of old dll

HeiniBlad13-Jul-07 20:45

HeiniBlad

13-Jul-07 20:45

Thanks. that site is good!

Find and Replace

RussBus13-Jul-07 4:50

RussBus

13-Jul-07 4:50

I have created a custom XML/Encryptor program and the last thing I need to do is get a Find and Replace function working. The program has been built using ICSharp, I am trying to use there SearchAndReplace class but am running into problems. I know that it is a specific library that I am asking for help on but I was wondering if anyone had any idea of how to us it here is the code I am using and the error that I am getting:

SearchAndReplace.SearchAndReplaceDialog l_oSerachnReplace = new SearchAndReplace.SearchAndReplaceDialog(SearchAndReplace.SearchAndReplaceMode.Search);
l_oSerachnReplace.ShowDialog();

I get the following error:

Resource not found : Icons.16x16.FindIcon

Form Scroll

rmedo13-Jul-07 4:42

rmedo

13-Jul-07 4:42

Hi All,
I want to make scroll in the from, i set Allow scroll property to true but it doesn't work, so if there is another option please anyone help me

Thanks alot

Re: Form Scroll

Paul Conrad13-Jul-07 12:00

Paul Conrad

13-Jul-07 12:00

Could you clarify what you are trying to accomplish? What are you scrolling?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: Form Scroll

rmedo13-Jul-07 12:51

rmedo

13-Jul-07 12:51

i want to scroll form itself coz it hold alot of controls and its size 900*800 so if the project run on any computer with resolution less then 1024*768 controls will not be appear, so can i make scroll in the form to be used in any resolution

Thanks for youe reply

Win MCI or DirectX

Sukhjinder_K13-Jul-07 4:24

Sukhjinder_K

13-Jul-07 4:24

Hi, I'm developing a MediaCenter Type of Application. There seem to be two options for playing Audio/Video using Media Control Interface (MCI) and DirectX. As I'm new to C# can you tell me which one should I choose and their respective benefits. My primary concern is that whatever I choose should put minimum load on the system. I'm open to other suggestions as well.

Thanks...

P.S: I havent particularly liked the approach required to use MCI.

Re: Win MCI or DirectX

Eduard Keilholz13-Jul-07 4:30

Eduard Keilholz

13-Jul-07 4:30

Erhm, i'd recommend DirectX. For now you can use it for just playing tracks, no problem, you can also use MCI instead. But if you'd like to expand the possibilities of your app, you'll be stuck to the MCI limitations.

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

Generating Salt

Brendan Vogt13-Jul-07 4:23

Brendan Vogt

13-Jul-07 4:23

Hi,

I have seen from the PetShop .NET project that they have the following method for creating salt:

private string GenerateSalt()
{
byte[] buffer = new byte[SALT_SIZE_IN_BYTES];
(new RNGCryptoServiceProvider()).GetBytes(buffer);
return Convert.ToBase64String(buffer);
}

SALT_SIZE_IN_BYTES = 16. Is this the best way to do it? Is this how the default membership provider does it?

Regards
ma se

Re: Generating Salt [modified]

Dave Kreskowiak13-Jul-07 6:22

Dave Kreskowiak

13-Jul-07 6:22

That's about how I do it. Don't generate a salt size too big otherwise you'll end up with a Base64 string the length of a aircraft carrier. I find that 10 to 20 bytes is sufficient.

I just got done explaining this to someone else, here[^].

-- modified at 12:33 Friday 13th July, 2007

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Remoting and Symantec firewall

Wjousts13-Jul-07 4:11

Wjousts

13-Jul-07 4:11

I having a weird problem with remoting and I think it is due to Symantec's firewall that we have installed on all our computers as part of IT's standard setup. In my application I have a remote object that the server publishes using RemotingConfiguration.RegisterWellKnownServiceType. The server then also gets a copy of the object itself using Activator.GetObject. This works fine if I'm connected to our corporate network. However, when I'm disconnected it doesn't work. I get a message that the "No connection could be made because the target machine actively refused it". The weird part is that once in a while, it actually does work!
I checked out our Symantec firewall (which I can't change settings on) and watched it as I tried to connect and I notice that the number of blocked inbound connections does increase when I attempt to start my server (but the number of allowed connections also increases). When I'm connected to the network, I don't get any increase in the number of blocked connections. Digging deeper, Symantec has a category called "Blocked unmanaged TCP/UDP inbounds" which increases when I try and start my server while off-line.
Does anybody know what it means by "unmanaged" in this context? It seems like the server registering the well known service type is accepted but the attempt to connect to that well know service is not. Is there a way to convince this POS firewall that it should allow my connection?
I'm totally screwed if I can't find a way around this Mad | :mad:

Re: Remoting and Symantec firewall

Paul Conrad13-Jul-07 12:01

Paul Conrad

13-Jul-07 12:01

Have you figured this one out?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: Remoting and Symantec firewall

Wjousts13-Jul-07 14:04

Wjousts

13-Jul-07 14:04

Actually, I just did. It seems that if I set rejectRemoteRequests when I create the TcpChannel on the server the firewall doesn't block it anymore. So I think the solution is to check when creating the server to see if I'm online and if not set rejectRemoteRequests and assume that the client has to be on the same computer (which it does, because we're offline anyway).
The only problem I see with this is if the computer was not connected when the server starts, but is then connected later (or vis-versa) but I don't think that's something I'm going to worry about.
It still mystifying as to why the firewall blocks activity on a port when not connected to the network, but has no problem with it when you are connected (and it could actually be a malicious attack).

Re: Remoting and Symantec firewall

Paul Conrad13-Jul-07 14:09

Paul Conrad

13-Jul-07 14:09

Wjousts wrote:
It still mystifying as to why the firewall blocks activity on a port when not connected to the network

That is really odd Suspicious | :suss:

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.