File and text encoding issue - C# Discussion Boards

Re: Passing Message from unmanaged dll to C# Windows Service

10-Jul-06 23:43

Hello

You can pass a delegate of a function that queues messages, then deal with it in the dll as a function pointer.

Check interoperability articles for details.

Regards Rose | [Rose]

Rashid.Mahmood10-Jul-06 23:59

Rashid.Mahmood

10-Jul-06 23:59

Thanx.

Is there any way like MessageFilter that work on threads other than UI threads.
Bcz i need a builtin message queuing system.

"Imagination is much more important than implementation"

Re: Passing Message from unmanaged dll to C# Windows Service

Nader Elshehabi11-Jul-06 1:15

File and text encoding issue

11-Jul-06 1:15

Hello

You can use the Windows API function PostThreadMessage() and supply it with your service's thread id, but catching the message would be a tricky part!! I don't have anything about it in my mind for now.

Yet why making things complicated for yourself??

Regards Rose | [Rose]

Heinz_10-Jul-06 21:15

10-Jul-06 21:15

Hi,

I have the following problem. I create a file using the SaveFileDialog class. The file gets created in ANSI encoding, this according to many programs including notepad and MS Word. But then i try to write strings in non english languages and i get those symbols you know. OK, to try to solve this issue i set the text i want to write to UTF-8 encoding for international character support but the problem is: Have you ever tried to write utf-8 or variants to an ascii file? it's a mess!

Is there a way to solve this problem in any way? Creating the file with different encoding (don't know how to do this cause the file gets created in ascii by force) or changing it's encoding type later.

Thanx.

Nader Elshehabi10-Jul-06 21:51

10-Jul-06 21:51

Hello

Heinz_ wrote:
The file gets created in ANSI encoding, this according to many programs including notepad and MS Word.

Who in the world said that?!?!?

You can create your file in any format you want. Besides, if you want to write text in UTF-8, here is a sample:

SaveFileDialog save = new SaveFileDialog();
save.ShowDialog();
StreamWriter Fs = File.CreateText(save.FileName);
Fs.WriteLine("Test");
Fs.WriteLine("اختبار");
Fs.WriteLine("épreuve");
Fs.WriteLine("Prüfung");
Fs.WriteLine("试验");
Fs.WriteLine("試験");
Fs.Flush();

Regards

Heinz_11-Jul-06 8:08

11-Jul-06 8:08

Hi, thanx for your answer and your code. I know taht your code works cause i have used this write method tons of time but this time i'm using the Stream class returned by SaveFileDialog.OpenFile(), this write method uses arrays of bytes to write to the files so characters in strings must be converted to bytes corresponding to the encoding type. This is where this encoding type compatibility game begins.

I think i'll have to recode this block of code again to use the great StreamWriter, thanks in advance,

Heinz

Heinz_11-Jul-06 8:18

11-Jul-06 8:18

Nader Elshehabi wrote:
Heinz_ wrote:
The file gets created in ANSI encoding, this according to many programs including notepad and MS Word.

Who in the world said that?!?!?

Regarding to this, when you call SaveFileDialog.ShowDialog() and the DialogResult is OK, or al least when you call SaveFileDialog.OpenFile(), your file gets created automatically and by force in an ANSI or ASCII formatting, check this info by opening the file with any word editing software that can show you the formatting type info.

This is how it works, i didn't say anything, don't blame me.

Heinz_11-Jul-06 8:38

11-Jul-06 8:38

I tried the above write method, it works ok, it writes international characters (checked by opening it with notepad) and the encoding type of the file is UTF-8. The file i create and write is a csv.
I have another problem now, when i open this file with Excel these special characters are replaced by those weird symbols. Thats an Excel bug but how to solve it?

Thanks.

Nader Elshehabi11-Jul-06 11:27

Link buttons are not working....!

11-Jul-06 11:27

Hello

For this you have to check the language settings of Excel, or even your windows. Sorry, I don't think I can be of an assistance there.

Regards Rose | [Rose]

ayyp10-Jul-06 20:24

ayyp

10-Jul-06 20:24

hi all,in my web application link buttons are not working,it works well upto yesterday but today morning it's not working what will be the problem.in the link button click event,i just add the code to redirect the page nothing more.
what will be the prob.....i really struck with this prob.... Confused | :confused:

Regards,
ayyp

Re: Link buttons are not working....!

thomasa10-Jul-06 23:37

thomasa

10-Jul-06 23:37

If you use Visual Studio, it sometimes remove the click evnet in the "Web Form Designer generated code"

auto upload/export of a downloaded CSV file to SQLSERVER on the server [modified]

amitcoder8310-Jul-06 19:50

amitcoder83

10-Jul-06 19:50

my application is actually a web application where i manually upload CSV file to the database.but i want to automate the process,so i have thought of a second stage to this application i.e through a windows application i would download the CSV file from the NSEIndia.com site automatically and then upload the same to SQLServer on the server.i dont have any idea about auto-upload i.e exporting the data to the database automatically.it would be a great help to me if any one could provide me a solution either in VB.Net code or C# code.

AMIT(TATA CMC)

-- modified at 4:51 Tuesday 11th July, 2006

Re: auto upload/export of a downloaded CSV file to SQLSERVER on the server

Nader Elshehabi10-Jul-06 21:29

Re: auto upload/export of a downloaded CSV file to SQLSERVER on the server

10-Jul-06 21:29

Hello

amitcoder83 wrote:
i am facing a problem with upload

Pardon me if I ask... What is exaclty your problem??? Big Grin | :-D

amitcoder83 wrote:
if any one could provide me a solution

Indeed, but to what?? Confused | :confused:

Regards

amitcoder8310-Jul-06 22:50

amitcoder83

10-Jul-06 22:50

the actual problem is upload,i dont have any solution for automatic uploading can u give me a solution

Amit(TATA CMC)

Re: auto upload/export of a downloaded CSV file to SQLSERVER on the server

Nader Elshehabi10-Jul-06 23:39

10-Jul-06 23:39

Hello

There should not be any problem. Just work it out systematically.

1- You mentioned that downloading isn't a problem. So should the upload.
2- you got a CSV file, so you should parse it fist. I think that's easy, isn't it??
3- About the auto upload. If you mean for example that you put the files in a certain folder. Then when you launch the program it will automatically enumerate the files and upload them to our SQL server, hen what would be the problem here?
4- Uploading the values of the CSV files -or even the entire files without parsing-, is just a matter of connection to the sql server on the net. There are BOOKS on that, not just articles. Yet These following links may give you a push in the right direction:
CodeProjects Databse Page[^]

Especially this article:
Uploading / Downloading Pictures to / from a SQL Server[^]

After all that, I still have a bad feeling that I didn't get your problem correctly, did I? If so, posting the code that's causing you the problem would be helpful.

Remember that SQL server on the internet can be dealt with as if it's on a LAN or even on your PC -with some differences of course;)-. Just take care of the settings of the server.

Time to do some homework.

Regards Rose | [Rose]

Custom Cotrol

Sashulika10-Jul-06 19:49

Sashulika

10-Jul-06 19:49

How I can write a custom control, like Add/Remove Programs List in Control Panel (Windows)?

Re: Custom Cotrol

Nader Elshehabi10-Jul-06 21:24