Re: 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

Question about string and int in c# ( IDE 2005 )

10-Jul-06 21:24

Hello

Sashulika wrote:
like Add/Remove Programs List

Like it in what exactly??

Ps.
There is a project named UserControl int he new projects list if that's all you want.

Regards Rose | [Rose]

Re: Custom Cotrol

Josh Smith11-Jul-06 4:18

Josh Smith

11-Jul-06 4:18

That's not a question that can be answered on a message board. Creating custom controls can be very complicated. You'll need to read whatever is in MSDN regarding custom control development. Then look for samples on CP. Who knows, there might already be a control that does what you need out on the web somewhere.

:josh:
My WPF Blog[^]

Yanshof10-Jul-06 19:10

Yanshof

10-Jul-06 19:10

Hi All,

I have some int that i use in my project.
I need to print the value - but i must print it in 2 digit place.
I mean that if the int is 2 i need to print it as "02" and if its 15 it need to be as string "15".

How can i do it ?

Thanks for any help.

Re: Question about string and int in c# ( IDE 2005 )

S. Senthil Kumar10-Jul-06 19:28

S. Senthil Kumar

10-Jul-06 19:28

This[^] MSDN page lists all the custom numeric formatting strings. For your requirement, all you need to do is

int x = 2;
string formattedValue = x.ToString("00");

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

Re: Question about string and int in c# ( IDE 2005 )

wasife11-Jul-06 8:30

wasife

11-Jul-06 8:30

Lets suppose that your int is i. Then you can use following code:

String intI=i.ToString();
if(intI[0]!='0')
intI="0"+intI;
Console.WriteLine(intI);

Regards,
Wasif Ehsan.

Interop Error while including Microsoft outlook dll

aaraaayen10-Jul-06 18:55

aaraaayen

10-Jul-06 18:55

I am adding reference for microsoft outlook. i have selecting microsoft outlook 11.0 object library.

but in my code it gives error in c#.net 2005. but its working in visual studio 2003. Please help me.

Error:

The type or namespace name 'Interop' does not exist in the namespace 'Microsoft.Office' (are you missing an assembly reference?)

using System;
using System.Collections.Generic;
using System.Text;
//using System;
using System.Reflection; // to use Missing.Value

//TO DO: If you use the Microsoft Outlook 11.0 Object Library, uncomment the following line.
using Outlook = Microsoft.Office.Interop.Outlook;

namespace CheckOutlook
{
class Program
{
static void Main(string[] args)
{
try
{
// Create the Outlook application.
// in-line initialization
Outlook.Application oApp = new Outlook.Application();

// Get the MAPI namespace.
Outlook.NameSpace oNS = oApp.GetNamespace("mapi");

// Log on by using the default profile or existing session (no dialog box).
oNS.Logon(Missing.Value, Missing.Value, false, true);

// Alternate logon method that uses a specific profile name.
// TODO: If you use this logon method, specify the correct profile name
// and comment the previous Logon line.
//oNS.Logon("profilename",Missing.Value,false,true);

//Get the Inbox folder.
Outlook.MAPIFolder oInbox = oNS.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox);

//Get the Items collection in the Inbox folder.
Outlook.Items oItems = oInbox.Items;

// Get the first message.
// Because the Items folder may contain different item types,
// use explicit typecasting with the assignment.
Outlook.MailItem oMsg = (Outlook.MailItem)oItems.GetFirst();

//Output some common properties.
Console.WriteLine(oMsg.Subject);
Console.WriteLine(oMsg.SenderName);
Console.WriteLine(oMsg.ReceivedTime);
Console.WriteLine(oMsg.Body);

//Check for attachments.
int AttachCnt = oMsg.Attachments.Count;
Console.WriteLine("Attachments: " + AttachCnt.ToString());

//TO DO: If you use the Microsoft Outlook 10.0 Object Library, uncomment the following lines.
/*if (AttachCnt > 0)
{
for (int i = 1; i <= AttachCnt; i++)
Console.WriteLine(i.ToString() + "-" + oMsg.Attachments.Item(i).DisplayName);
}*/

//TO DO: If you use the Microsoft Outlook 11.0 Object Library, uncomment the following lines.
/*if (AttachCnt > 0)
{
for (int i = 1; i <= AttachCnt; i++)
Console.WriteLine(i.ToString() + "-" + oMsg.Attachments[i].DisplayName);
}*/

//Display the message.
oMsg.Display(true); //modal

//Log off.
oNS.Logoff();

//Explicitly release objects.
oMsg = null;
oItems = null;
oInbox = null;
oNS = null;
oApp = null;
}

//Error handler.
catch (Exception e)
{
Console.WriteLine("{0} Exception caught: ", e);
}

// Return value.
//return 0;

}
}
}

Prya

Re: Interop Error while including Microsoft outlook dll

Nader Elshehabi10-Jul-06 21:16