Re: excel is behaving strange - C# Discussion Boards

Re: RegEx bug in .NET Framework!!

Michael Sync13-Jul-07 21:18

Michael Sync

13-Jul-07 21:18

thanks. it's very interesting....

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

MySQL inserting UnicodeStr

pnpfriend13-Jul-07 6:48

pnpfriend

13-Jul-07 6:48

Hi All,
I have a unicode string

string tempstr = "פסטיבל סגול ה- 11 - למדיטציה ואהבה";
odbcCmd.Text = "update myTable set testField '" + tempstr + "' where myIndex=3";
odbcCmd.ExecuteNonQuery();

After I run ExecuteNonQuery(), I found '???????' in the testField instead of Hebrew chars. I also tested out with languages other than English, it is inserting '????' instaead of unicode string. However, I run that Update string in the mySQL browser (not using any program), it inserted info/nicode string correctly.

Why is it?
I look at the field properties and it was set to utf8.
how can I insert non-english characters ino db please.

Thank You.

Re: MySQL inserting UnicodeStr

Giorgi Dalakishvili13-Jul-07 7:03

Giorgi Dalakishvili

13-Jul-07 7:03

Have a look at this: Mysql Unicode[^]

#region signature
my articles
#endregion

Re: MySQL inserting UnicodeStr

pnpfriend13-Jul-07 8:46

pnpfriend

13-Jul-07 8:46

Thank You Giorgi,
I looked at the link you gave it to me and I tried it.

My TableOptions are following:
MyISAM Storage Engine, Charset=utf8, Collation= Utf8_general_ci

I tried with following two myConnection strings
1) cnnString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=imagingsql01;UID=roscoe; PASSWORD=roscoe;OPTION=3; Data Source=localhost; Persist Security Info=yes;character set=utf8;Database=myDBName;";//CHARSET=utf8;";

2) cnnString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=imagingsql01;UID=roscoe; PASSWORD=roscoe; OPTION=3; Data Source=localhost; Persist Security Info=yes;CHARSET=utf8;Database=myDBName;";

I tried both ways and still inserting '??????' to the table.
What else do I need to do to the table/code so the inserting can be done in proper way.

Thanks.

Re: MySQL inserting UnicodeStr

Giorgi Dalakishvili13-Jul-07 8:50

Giorgi Dalakishvili

13-Jul-07 8:50

Which driver are you using to connect to Mysql? Also, check this link: http://dev.mysql.com/doc/refman/5.0/en/faqs-cjk.html[^]

#region signature
my articles
#endregion

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

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