problem with Arabic language.

Hello,

I have been haunted by this issue for a long time. I have a list of cities in a .DBF file called as "cities1.dbf". When i query the Arabic field & try to display in a drop down list, it shows some garbage values & not the actual arabic text.

Is this something to do with the encoding decoding. Earlier i tried do solve this with the .net Encoding decoding, but couldnt get success.

Please advise.

Expand|Select|Wrap|Line Numbers

 
.aspx

----------

<body>

    <form id="form1" runat="server">

    <div>

    Cities_Arabic <asp:DropDownList ID="DropDownList1" runat="server" DataValueField ="city_lcase" DataTextField="city_a"></asp:DropDownList>

    </div>

    </form>

</body>
 
.aspx.vb

------------

Dim cityName As String = "_cities"

Dim strSql As String = "SELECT * FROM cities1"

DropDownList1.DataSource = generalClass.ExecuteDataTableQueryDBF(strSql, cityName)

DropDownList1.DataBind()
 
Public Shared Function ExecuteDataTableQueryDBF(ByVal SelectSTR As String, ByVal city As String) As Data.DataTable

        Dim oCnn As New OleDbConnection

        Dim iCount As Integer = 0

        Dim strSql As String

        Dim da As New OleDbDataAdapter

        Dim dt As New DataTable

        Try

            oCnn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("DBFConnetionString1").ToString + city + System.Configuration.ConfigurationManager.AppSettings("DBFConnetionString2").ToString
 
            If oCnn.State = ConnectionState.Closed Then

                oCnn.Open()

            End If
 
            strSql = SelectSTR

            da = New OleDb.OleDbDataAdapter(strSql, oCnn)

            da.Fill(dt)
 
        Catch ex As Exception

        Finally

            If oCnn.State = ConnectionState.Open Then

                oCnn.Close()

            End If

        End Try

        Return dt

    End Function

Here is a link to the problem screen shot which i am facing.

http://picasaweb.google.com/lh/photo...eat=directlink

Thanks & regards,

Aug 30 '09 #1

Subscribe Post Reply

4148

hash4sp

hello.. is there anyone who can give me some suggestion on this please

Nov 20 '09 #2

Frinavale

9,735

Expert Mod 8TB

I think this has a lot to do with the character set that is being used.
If the character set being used doesn't support Arabic characters then you won't be able to display them..

Check out this thread on Arabic in ASP.

Also check out this MSDN article on Character Set Recognition.

And check out this CodeProject article about Encoding in ASP.NET.

-Frinny

Nov 20 '09 #3

by: Hari Shankar | last post by:

Dear all I am supposed to develop a world ready application in C# 2003 (which will run in xp) which should aupport Arabic & Hebrew also. My doubts(Fears) are: 1. Do i have to create all the...

C# / C Sharp

VB and Arabic language

by: Shoshinsha | last post by:

Does anyone have some experience with creating VB application where the captions for forms and buttons are in Arabic ?

Visual Basic .NET

i want to set the arabic language as a default language

by: haitham | last post by:

hi suppot team can any one tell me how i set arabic language as a default language when i start the project thx

Visual Basic .NET

open() and Arabic language

by: MaaSTaaR | last post by:

Hello ... firstly , sorry for my bad English . i have problem with open() function when i use it with file which name in Arabic , the open() will not find the file , and i am sure the file is...

Python

How to convert the web page into Arabic language

by: shizah | last post by:

First of all thanks alot for ur response. Let me clear my point again to u so that u can suggest me a better advice. Well sir u r very much right in this contrast that it can be implemented in my...

ASP / Active Server Pages

Arabic Language

by: taroo2ah | last post by:

Hello everybody, Making backup of a MySQL database allways ruins the data inside it! I have tried many things and I am now againest something that I need to know: what is the deference between...

MySQL Database

jtextfield donot accept Arabic language font

by: ahmed222too | last post by:

the jtextfield donot accept Arabic language font when i run this code jtextfield.settext="ذهب الولد إلى المدرسة"; the arabic font change into another font in the jtextfield

Java

CustomValidation control doesn't work with Arabic language

by: JustRun | last post by:

Hi, I'm developing a web application using ASP.NET2.0 with C#, I have tried to use custom validation controls to validate my forms, it worked very well in the English language , but when i test it...

.NET Framework

MSGBOX in ARABIC language

by: wassimdaccache | last post by:

Dear all I am using office 2007 SP2 I am trying to write a message box. msgbox "هل تريد حفظ هذه المعلومات ؟",vbYesNo Everything is OK but I am getting unknown symbole in place of the...

Microsoft Access / VBA

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

problem with Arabic language.

Similar topics