I am having issues with the Arabic language when trying to display dates and times. I seem to be unable to get the formatting to work on a date, or on a time, but it works on a date and time. Other languages seem to be fine. Any thoughts on why this is? (see image link below) Also, the Arabic formatted date is very different than the normal date (e.g. 8/20/2010 is showing as 10/09/31). Is this accurate?
[Code]...
I have now started posting to a MySQL database created by someone else. I have no ability to change the table structure.Two questions:
1) There is a date field and a time field that loosely tracks the last edit date and time. Both are fields set up as DateTime in the database. The date field always has the proper date but the date and time portion shows as
2011-11-27 00:00:00
However, the time field shows as
1899-12-30 23:16:58.
When I am updating with the following code
strSQLCmd.Parameters.AddWithValue("@EditDate", Date.Now)
strSQLCmd.Parameters.AddWithValue("@EditTime", TimeOfDay)
The date field displays
2011-11-27 23:40:26
and the time field displays
0001-01-01 23:40:26
I'm not sure how to format the date field without time and the time field with Dec 30 1899.Question 2) I will be adding some tables and will be wanting to track date and time of first entry as well as date and time of last edit. (this may have been better posted in the Database forum, if so, sorry)
For those of you who have done this before, would you mind sharing best practises? I am wondering why would you use two fields, one for date and one for time, when the field is a date/time field to begin with. I've seen this before in another database as well. I'm just trying to work out the logic here.
I am trying to create a small application which does mathematical calculations using dates and times. Specifically, to determine the period of time between two specific dates and times.
View 2 RepliesI have this really weird problem, in excel I'm using a user form to get the date from the user. I used the calendar control in toolbox. So when the user selects the date it goes to its text box, still in the user form correctly formatted as dd/mm/yy.
[Code]...
I have an MS Excel column, 97 or 2003, containing Arabic. I want to import it to an Existing MS Access 97 database with various columns. Whichever 'path' I take, Import, Copy/Paste, Open etc, in the end, when it is displayed in the MS Access 97, the Arabic text is displayed as Hebrew is fine. I could write vb code to translate character character if this is the only way but I don't quite understand what has to be done.
View 1 RepliesIm using VB to set default dates and times for the file names when a form is saved through InfoPath, this is what I have so far:
[code...]
This works but i need to format it to this:
ddmmyyy and hhmmss
I need zero's before single characters as if its only a single character then it only displays 1 eg if its 9 in the morning it'll display 9 rather than 09 and i need 09.
In my app I present to the user an option to customize the name of the file that gets produced. The format string the program reads is something like "yyyyMMdd-%1-%2-%3-%4" which the user can customize to his liking. In this case the format of the date is yyyyMMdd and the %1 is the trip number like 1000P, %2 is the origin code like PTTTT, %3 is the destination code like PHYUD, and %4 is a secondary stop code like YYYY123. I'm having problems taking the actual data and formatting into the custom string. I believe its the date format that I'm getting stuck on.
So far I have
sOut = txtFormatPattern.Text
sOut = sOut.Replace("%1", "1000P")
sOut = sOut.Replace("%2", "PTTTT")
sOut = sOut.Replace("%3", "PHYUD")
sOut = sOut.Replace("%4", "YYYY123")
sOut = myDate.ToString(sOut) 'date is July 01, 2007
The output is "20070701-#1000P-PTTTTP12YUD (YYYY123)"
The problem obviously here is my last conversion. The string contains key characters that denote a part of the date specifically in PHYUD. So my question is how can I give my user the flexibility to format the output as they wish and then convert that properly?
Is it just me or is it so that a DateTimePicker can only be used for entering dates or times but not both?
View 9 RepliesI want my program to be able to create a '.txt' file when it is run for the first time, with the date and time the program was accessed, and to be able to add new 'logs' of program history every time it is accessed. What i mean is that i want my program to be able to create a '.txt' file, and then fill in the dates and times when the program is opened.
View 7 Replies[Code]...
and Also statment to search between 2 Times. [URL]
I want to enlarge an image, possibly up to 32 times or 64 times bigger than original dimensions (so that the user can see each pixel) if possible. The following is a simple function that I have to enlarge an image.
Private Function xEnlarge(ByVal Source As Image, ByVal Rate As Double, Optional ByVal Quality As Drawing2D.InterpolationMode = Drawing2D.InterpolationMode.HighQualityBicubic) As Image
[Code].....
I have two dates. [code] How to print all dates between these two dates in one listbox, for example: [code]
View 8 Repliesi am getting all the arbic id3 tag as TAG?
[Code]...
I have some VB .NET software that interfaces to a load of old (but sound) COM objects. The VB provides a GUI for the COM objects, part of which consists of setting various options on the COM objects - several of which relate to string formatting.I have a simple pair of VB .NET functions that convert basic %f, %d, %g formats to/from .NET equivalents using a large select case covering specific common strings, but they don't cover all formats.[code]Before I start diving in and making it more versatile with some parsing, does anyone know of a class (eg VB or C# .NET) that provides a decent ready-made implementation? Or perhaps some regexp wizadry could be used?
View 2 RepliesI want to add Arabic typing in VB.Net. How can I do that?
View 1 RepliesI am designing a multlingual system. At one time, a person might want to use Arabic as his language of communication. In the form i have combobox and a richtexbox. I want If someone has selcted Arabic from the combobox, the richtextbox down to be formatted such that whichever letter a person types in it is in Arabi. The code I am using is stilling giving me english characters.
If
ComboBox1.Text = "Arabic" Then
Select Case sender.tag
Case ar
[Code]....
Say the user specifies these two dates....
Start Date: 2010-12-05
End Date: 2011-01-15
If I select December 2010 I should get the folllowing
startdate = 2010-12-05
enddate = 2010-12-31
Select January 2011 then
startdate = 2011-01-01
enddate = 2011-01-15
Should I subtract dates? How can I get the start and enddate for the current month/year based on the overall start and end date.I'm coding in vb.net.
I'm using two datetimepicker controls to set the start and end dates for a range of dates I'm searching for.I want to make sure that the start date selected is not greater than the end date. This code works, but it runs the messagebox prompt twice for some reason. I've tried to ignore it from doing this, but it's not working. Can someone tell me what's wrong?
Private Sub dtpStart_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dtpStart.ValueChanged
[Code]...
I have just started using vb.net and I have a checked list box with times throughout the day shown as
00:00 - 00:14
00:15 - 00:29
00:30 - 00:44
00:45 - 00:59
What I am trying to find is a way to get the current time and find which list item it fits into. What I think I need to do is to first of all get the current time and then go through the list splitting each item into 2 times and seeing if the current time fits. For example: Split the item 00:00 - 00:14 to 00:00 and 00:14 and then check if the current time is more than 00:00:00 but less than 00:14:59 and if so do certain task.how to go about taking each list item and splitting it into 2 separate times so I can check between them?
how to convert from arabic to braille?
View 1 RepliesI'm trying to compose a String from multiple Strings, where some of the Strings may be in Arabic letters, the problem is that when I concatenate them, their order is being messed !!
For example, I have the following Strings:
Ref1
مسكه
2
Left
I want to concatenate them with the same previous order seperated by "-", but instead I get Ref1-مسكه-2-Left, as you can see, 2 is written before مسكه Does anyone know how to fix this problem, because it's really important in my case to have the exact same order, and I don't know where or when I might have these arabic strings, because it's being entered by User.
I'm using the following code to display an arabic date:
[Code]....
Today this is displaying as 161432. However, according to a user, the arabic text should be in the middle with the year 1432 at the end. However, when you highlight the text, it highlights back to front.
I am using vb,net in windows application (3.5). I have string for arabic date such as "25-05-1432". I want to convert it as Date with the same format.
View 5 RepliesI am looking for a way to convert the Arabic numerical string to an English
numerical string "0123456789"
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
dim Anum as string =
dim Enum as string =get_egnlishNum(Anum)
End Sub
private function get_egnlishNum(byval _Anum as string) as string
''converting code
End function
I want to insert an array of strings using Arial Unicode for an Arabic Dictionary. I already had one with Xp but as soon as I changed my operating system to Vista, the string switched the 1 and last place of the Arabic Letters around. And they are no longer correct spellings?
View 3 RepliesI'm trying to print Arabic strings to a receipt printer. Using the class from this KB..[code]I can print Latin strings but not Arabic.[code]In the SendStringToPrinter method to account for the Arabic string but the printer still prints garbage. I also changed every ANSI reference to Unicode with no avail.I can send esc characters just fine but I can't print Arabic strings.I'm using VS2008 on WIN7 Ultimate 64bit. I've tried it on Star TPS100, Epson 88IV and printers from POS Bank specifically the A9.I've tried POS .NET put it doesn't solve my problem because it depends on the installed fonts in the printer, and the printers that..I'm using don't have Arabic fonts.Normal .net printer objects are ok for short receipts but too slow for long receipts and it cuts the receipt when it reaches A4 size.
View 1 RepliesI want program recognition speech in Arabic how can i do that
View 1 RepliesI am using this code to read data from Oracle Database. That data stored in Oracle is Navarchar2 data type but when It it display in gridview it looks like this. ?& ? ? My database Charaacter set is WE8MSWIN1252 Here is mY code through which I am reading from Oracle database.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim con = New OleDbConnection("Data Source=cms; User ID=cms20112012; Password=??????; provider=OraOLEDB.Oracle")
con.open()
[code]....
when i try to use it (with arabic lang, vb.net, installed arabic package,set languageID to arabic"&04...")then the compiler HUNG...i try to change the code many times to find if there are any error.but i didn't get an error also there are no support to this language...
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
[code]....
text-to-speech for English language using Visual Basic 2008
Dim speech speech = CreateObject("sapi.spvoice")
speech.speak(TextBox1.Text)
how this can be used for Arabic languages?