|
Oh, I get it now. Edit your post to add someting to it, don't post anohter.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi
How do I find a value in a excelsheet ex. "Sum=123" and pass it to a textbox with the row number? I don't know how to come further with this.
On Error Resume Next<br />
TextBox1.Text = xlWorkSheet.Range("A1:A10").Find( _<br />
What:="Sum=123", MatchCase:=False, _<br />
SearchOrder:=xlApp.ByColumns).Offset(0, 1).Value<br />
If Err.Number Then TextBox1.Text = "No Match Found"
modified on Sunday, April 6, 2008 4:43 AM
|
|
|
|
|
I have developed a program with too many date fields. I have used datetimepicker for this with formating dd/MM/yyyy.
This will create problem if any user have system date format in m/d/yyyy
So I want that when my program start it will detect system date format and if format is in m/d/yyyy then it converts into mm/DD/yyyy and at the time of closing my program it converts into it's original format.
If any one have any code in support of this problem, please send me immediatly.
Thanks
Pathak
|
|
|
|
|
hiiiiiiii..,,
why are u trying to change the system date format,
change your datetimepicker format to system format.
use below code
Format(DateTimePicker4.Value, "yyMMdd")
thanks
Bye..
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
If any user have date format in dd/MM/yyyy then I save 08/04/2008, it saved same and displayed in same format.
but if he changed his format in m/d/yyyy and i give 08/04/2008 then when we retrive date it shows lik 04/08/2008.
And if use format here then it creates problem with dd/MM/yyyy format.
|
|
|
|
|
The format is just change the display. The .Value is still a DateTime type.
Unless you use ToString() and not the DateTime value, then you got to look at how you save and retrieve the value.
|
|
|
|
|
As darklev pointed out, your base error is if you are storing your dates as a string. If you are using a database then you MUST use the date data type to store your data. If you persist in using a string to store the date your will never be free of the formating problem.
|
|
|
|
|
i have couple of csv files, some are comma separated, some tab separated, some are unicode and some are ansi.
what is the easiest way to find out what delimiter the file uses and its encoding.
thank you.
|
|
|
|
|
what do you mean by easiest ????
You want to know the delimeter/unicode with out opening the csv file.
??????????
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
no. maybe ill rephrase the question..
how do i do it ??
|
|
|
|
|
Haimbert wrote: what is the easiest way to find out what delimiter the file uses
Asking the user what it is.
Beyond that, you have to analyze the file to determine what the most likely delimeter is. You'd have to ask the user if the delimiter you've figured out is actually correct.
Haimbert wrote: what is the easiest way to find out ... its encoding.
This is generally impossible to determine reliably. But, the StreamReader class can attempt to figure out what the encoding is, but there is no guarantee it's going to be correct. Again, asking the user if what has been determined as most likely correct is the only way to be sure.
|
|
|
|
|
Hi,
1.
open the file and see if you can read it; you might use File.ReadAllLines for this.
most formats (e.g. UTF8) have some byte codes in front to indicate what encoding they are
using (look with a hex editor for 0xFF 0xFE or 0xFE 0xFF), so the system has a good chance
of reading them correctly by default.
2.
if you expect no comma's in fields and you find a comma, then comma is the delimiter.
same for tabs.
if you expect both to be possible, then you need two passes:
in the first pass, count comma's and tabs; the most popular will be the delimiter.
in the second pass, process the data.
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
Hello,
I am making an application which can control a pabx (telephone switch).
I connect my pc and the pabx via com port.
For the connection setup i have to send some characterlines to the pabx.
Sending normal ascii characters works fine. I use:
SerialPort.WriteLine(Chr(&H10) & Chr(&H2) & Chr(&H20) & Chr(&H2) & Chr(&H0) & Chr(&H10) & Chr(&H3))
However, i have to send also hex97 (for example).
Is there someone who can give me some information.
I guess i have to change the character set? But how?
Regards,
Bas
modified on Saturday, April 5, 2008 6:12 AM
|
|
|
|
|
Send Ascii value insted if Hexcode
example
i want to sent " charachter
SerialPort.WriteLine(Chr(34))
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
Hello Rajesh,
Thanks for your answer.
I tried but when i send the character instead of Hex then i stil have to use an other character set, because hex97 = character 151. Standard ascii set starts at 0 and ends at 127. Extended ascii character set starts at 128 and ends at 255. As i have to send hex97 or character 151 i guess i have to change the character set but i do not know how and to which character set.
Regards,
Bas
|
|
|
|
|
try with ChrW() insted of Chr()
reply me...
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
I tried, but it doensnt work 
|
|
|
|
|
first check u r encoding of serial port
set below encoding for UTF-8 support
SerialPort1.Encoding = System.Text.Encoding.GetEncoding(1252)
after try this code
Dim mybyte As Byte = 150
serialport.write(mybyte )
i think it will work
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
Hello Rajesh,
Thanks a lot, this works fine.
I have been working for at least two weeks on this problem and now within two hours you solved my problem.
Regards,
Bas
|
|
|
|
|
Welcome 
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
keninfo wrote: SerialPort.WriteLine(Chr(&H10) & Chr(&H2) & Chr(&H20) & Chr(&H2) & Chr(&H0) & Chr(&H10) & Chr(&H3))
However, i have to send also hex97 (for example).
So what's wrong with writing Chr(&h97)??
|
|
|
|
|
Hi,
if you need to send special byte values over SerialPort, forget about text, strings and
encodings, and use SerialPort.Write, which works with byte arrays, no encoding, no
translation. What you get is what you ordered.
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
Hi,
I have 1 server, I using VB.NET to create folder, so can i do?
Thanks
Socheat
|
|
|
|
|
Q. not clear
I have 1 server, I using VB.NET to create folder, so can i do?
????????????????????? ???????????????? /////////
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
Using the Directory class, just like you would with a local path using a drive letter specification. The path will change to a UNC format.
I hope you've brushed up on your Windows Networking skills.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
