C# Discussion Boards - CodeProject

Re: How to record every pressed button

Hesham Yassin7-Jun-07 0:36

Hesham Yassin

7-Jun-07 0:36

MUHHHAAHAHAHHAAH, I DID IT!!!1 Laugh | :laugh:

THANK FOR EVERY ONE WHO TRIED TO HELP ME! Rose | [Rose]

Inserting data into MySQL from .Net

happyheartcs6-Jun-07 8:07

happyheartcs

6-Jun-07 8:07

Hi All,
Actually I was't sure of which message board to choose.
Anyhow, my problem is that I select arabic data from MySQL table into a DataTable in VS.net but when I try 2 insert the selected data, it inserts it as '???' though I chose the "utf-8"character set in connection string.
It's just that when the records are fetched to .net table, they are transformed to "???"
Any clue how 2 solve this??

Thnx a lot in advance

Re: Inserting data into MySQL from .Net

Giorgi Dalakishvili6-Jun-07 8:24

Giorgi Dalakishvili

6-Jun-07 8:24

Which version of mysql are you running?

First make sure that you connection string looks like something like this:
"Server={0}; Port={1}; Database={2}; Uid={3}; Pwd={4}; Charset=utf8;"

In order to check if the actual records contain '???' or they are transformed into them after checking execute this query:

SELECT HEX(column_name)
FROM table_name;

IF it displays 3f then the data itself is ???

Re: Inserting data into MySQL from .Net

happyheartcs7-Jun-07 0:39

happyheartcs

7-Jun-07 0:39

I'm using mysql 4.1
The original data doesn't contain '?????' & yeah my connection string looks like u said Frown | :(

Any clue??

Thanks a lot

Re: Inserting data into MySQL from .Net

I Believe In GOD6-Jun-07 8:38

I Believe In GOD

6-Jun-07 8:38

Hi

I was have the same problem

I solve it like this ......

-- My DataBase Charset was Latin_swidsh_c1

-- when I have to insert any word any recored in arabic I have to run this Query , it's like that
Exactly....

set names cp1256

and when I found my old project I will write it exactly ...

hope that will help you ... for now

cause in the past I got sick of this problem

but thank GOD it's solved now ... so I will search for you ... it's promise Smile | :)

Have a good day ...

I know nothing , I know nothing

Re: Inserting data into MySQL from .Net

I Believe In GOD7-Jun-07 3:03

I Believe In GOD

7-Jun-07 3:03

ok now here we go

I will tell you exactly what I did to solve this

just make sure that when you create the database it has

latin1_swedish_ci Charset

and the all other things are default ,

my replay before was for Php & MySql ......... ( set names cp1256 ) sorry

have a good day

I know nothing , I know nothing

Irda

Rafnunes6-Jun-07 6:39

Rafnunes

6-Jun-07 6:39

Hi
I need send bytes and received to a dummy device via infrared.

I creat port com based in serial com component framework 2.0, and da name port i consult da regedit and obtain this information.

The port is open, but when i send a array of bytes the program guive me a IOException.

serialP_.Write(buffer,0,buffer.Lenght);

Please help... Sigh | :sigh:

RafNunes

Re: Irda

Judah Gabriel Himango6-Jun-07 7:20

Judah Gabriel Himango

6-Jun-07 7:20

What's the error message you're receiving?

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Master's Decree: It's By My Spirit (audio)
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Re: Irda

Rafnunes6-Jun-07 7:25

Rafnunes

6-Jun-07 7:25

The error is IOException

Re: Irda

Dave Kreskowiak6-Jun-07 7:32

Dave Kreskowiak

6-Jun-07 7:32

That's no different that what you already said. What does the Message property in the IOException say?

A guide to posting questions on CodeProject[^]

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

Re: Irda

Rafnunes6-Jun-07 7:46

Rafnunes

6-Jun-07 7:46

The problem is the Message property return "IoException"...

Re: Irda

Dave Kreskowiak6-Jun-07 8:22

Dave Kreskowiak

6-Jun-07 8:22

OK. SO now, without seeing the code that throwing the exception, there's really nothing to tell you. There's about a 20 different reasons this can fail.

A guide to posting questions on CodeProject[^]

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

Re: Irda

Judah Gabriel Himango6-Jun-07 8:58

Judah Gabriel Himango

6-Jun-07 8:58

Is there an InnerException? Maybe if you could copy the exception details to the clipboard and paste it here, we could better help you out.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Master's Decree: It's By My Spirit (audio)
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Re: Irda

Rafnunes6-Jun-07 11:36

Rafnunes

6-Jun-07 11:36

This is the code i have writte,

<br />
<br />
<br />
<br />
<br />
 static   byte[] bufferBurst = new byte[22] { 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B, 0x5B };<br />
        static void Main(string[] args)<br />
        {<br />
            string portCom = "COM";<br />
            RegistryKey regkey = Registry.LocalMachine.OpenSubKey("Drivers\\BuiltIn\\IrCoMM");<br />
<br />
            if (regkey != null)<br />
            {<br />
                portCom += ((int)regkey.GetValue("Index")).ToString();<br />
                regkey.Close();<br />
            }<br />
            SerialPort sr = new SerialPort(portCom);<br />
            try<br />
            {<br />
<br />
                sr.RtsEnable = true;<br />
                sr.DtrEnable = true;<br />
                sr.BaudRate = 19200;<br />
<br />
                sr.Open();<br />
                sr.Write(bufferBurst, 0, bufferBurst.Length);<br />
                sr.Close();<br />
<br />
            }<br />
            catch ( IOException io)<br />
            {<br />
                Console.WriteLine(io.Message);<br />
                sr.Close();<br />
            }<br />
        }<br />

and the exception is:

InnerException = null
Message = IOException
HResult = -2146232800

When i start i think this type of hardware " IRDA" is very simple, but now.. and the home site to irda i have pay to acesse, but i'm not the soluctions for my problem is there.. Sigh | :sigh:

Re: Irda

Judah Gabriel Himango7-Jun-07 4:25

Judah Gabriel Himango

7-Jun-07 4:25

If you step through code in the debugger, it finds the registry key? If it doesn't, the serial port would be trying to use COM, which I don't believe will work (needs to be COM1, COM2, etc. right?)

Another thing to try would be different baud rates.

Of course, there is something physically connected to the serial port, right?

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Master's Decree: It's By My Spirit (audio)
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

C# code location

TheShaver6-Jun-07 6:29

TheShaver

6-Jun-07 6:29

Hi all,

Is there an equivalent in C# to the old, stupendously useful C++ __FILE__ and __LINE__ (and __FUNCTION__) preprocessor macros?

At the moment, I'm creating a StackFrame and reading information out of that, but it seems a bit silly to do that when the code location is known by the compiler at compile-time.

Thanks in advance Smile | :)

Re: C# code location

Judah Gabriel Himango6-Jun-07 7:10

Judah Gabriel Himango

6-Jun-07 7:10

You might be surprised to know this question has been asked and answered a number of times: Google for C# __file__ __line__[^]

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Master's Decree: It's By My Spirit (audio)
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Re: C# code location

TheShaver6-Jun-07 7:16

TheShaver

6-Jun-07 7:16

hmm thanks. the solutions proposed all use the stack frame I ended up using. Sounds like a good feature to add to the preprocessor next time around (because the stack frame hack obviously won't work consistently in release builds).

Re: C# code location

Judah Gabriel Himango6-Jun-07 7:23

Judah Gabriel Himango

6-Jun-07 7:23

It should work consistently in release builds provided you supply the app's .pdb with the release build, I believe.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Master's Decree: It's By My Spirit (audio)
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Re: C# code location

TheShaver6-Jun-07 14:28

TheShaver

6-Jun-07 14:28

Release build optimisations (at the very least, inlining code) will screw with the expected stack. I wouldn't hold out any hope of stack frames acquired in release builds to be accurate.

Re: C# code location

Judah Gabriel Himango7-Jun-07 4:23

Judah Gabriel Himango

7-Jun-07 4:23

Mmmm, good point.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Master's Decree: It's By My Spirit (audio)
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Drag and Drop

Sergio Paque6-Jun-07 6:28

Sergio Paque

6-Jun-07 6:28

Hi,
I'm currently making an application that simulates a virtual drive using a file as storage and FAT32 as filesystem. I've made an explorer-like user interface, and I want to implement drag and drop from my application to explorer, but I cannot use the .net drag and drop directly since I store the items with a custom format as I said above.
I've thought of using the DragLeave event to create the dragged file as a temporary file and actually drop this temporary file.
Is this ok? Confused | :confused:

Or is there a better way of doing it?
Thanks in advance. Smile | :)

Re: Drag and Drop

I Believe In GOD6-Jun-07 6:38

I Believe In GOD

6-Jun-07 6:38

you can Use MemoryStream to stroe your File Bytes in it

I know nothing , I know nothing

Getting Files that start with letters only

hebes_996-Jun-07 5:57

hebes_99

6-Jun-07 5:57

Hi...

Newbie to C#..so please be kind...

I am trying to get a list of files that start with letters only (avoiding files that start with ~ for example). Here is my simple code, which of course does not work:

<br />
DirectoryInfo dir = new DirectoryInfo("C:\Some Directory");<br />
FileInfo[] files = dir.GetFiles("[^a-zA-Z]*.doc");<br />

What am I missing?

TIA for any help. Sorry if this has been posted. I searched, but could not find....

J

Re: Getting Files that start with letters only

Luc Pattyn6-Jun-07 6:04

Luc Pattyn

6-Jun-07 6:04

Hi,

AFAIK you can use wildcards in GetFiles, the same you can in a DOS window,
or the Explorer's search pane, but nothing more fancy.

So you end up with two choices:
- do GetFiles("*.doc") and skip the files you dont like; (you would need
Path.GetFileName to extract the short file name again);
- create a loop with myChar going from 'a' to 'z' and do GetFiles(""+myChar+"*.doc"),
or alternatively construct a constant string that holds acceptable starting letters
and do a foreach myChar on it.

Smile | :)

Luc Pattyn

[My Articles] [Forum Guidelines]

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