[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1290
  • Last Modified:

Tool With Unicode in VB6.0

I writed 1 program in This program I have use some tool Presentive database (eg: ListView,DataGrid). But now,  My  Database SQL server need tranlate to Unicode.
Please help me!
Thank you.
0
thang74us
Asked:
thang74us
  • 3
1 Solution
 
Shiju SasidharanAssoc Project ManagerCommented:
hi
Can u please be little bit more clear
>>My  Database SQL server need tranlate to Unicode.
u r trying to display contents from database to ListView, Datagird?
or trying to do the reverse process or something else ?
or post ur code, where u got stuck
;-)
Shiju
0
 
thang74usAuthor Commented:
Form Load()

Dim mObjrecord As New ADODB.Recordset
Dim Item As ListItem
Dim txt_Sql as string

Set Conn = New ADODB.Connection
Conn.Open "Provider=sqloledb;Data Source=THANG-TH ;Initial Catalog= Csdldiachat ;User Id=Webinternet;Password=Internet; "
  txt_SQL = "Select Id,name from VungKhoangSan"
mObjrecord.open txt,conn
  Do While Not mObjrecord.EOF
      Set Item = ListVkhoangsan.ListItems.Add(, , mObjrecord.Fields(1))
      Item.SubItems(2) = mObjrecord(0)
      Item.SubItems(1) = mObjrecord(1)
      mObjrecord.MoveNext
  Loop
  mObjrecord.Close

eg:
name old: "Than Khe chµm"
but name new is Unnicode "Công ty thạn Khe chàm"
 
help me.
0
 
Shiju SasidharanAssoc Project ManagerCommented:
0
 
Shiju SasidharanAssoc Project ManagerCommented:
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now