-

- 加为好友
- 发送私信
- 在线聊天
-
figo8848
- 等级:

- 可用分等级:
- 总技术分:
- 总技术分排名:
- 结帖率:
|
| 发表于:2008-08-18 17:39:09 楼主 |
本人有以*.rtf文件,导入RichTextBox后数据如下: ******* 1 2 3 4 ...... 相隔51个 小张 小李 ...... P11111 P22222 ...... 我想把RichTextBox所有的数据导入到access里面去 形成 1 小张 P11111 2 小李 P22222 请问有什么好的解决办法吗? 本人从网上找了如下代码: Option Explicit Private Declare Function SendMessageBynum& Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParam As Long) Private Declare Function SendMessageByString& Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParam As String) Const EM_LINEINDEX = &HBB '判断指定行第一个字符的编号 Const EM_LINELENGTH = &HC1 '判断一行长度 Const EM_GETLINE = &HC4 '从编辑控件取回…行的内容 '***************************************************************** Function GetLineText(CTextBox As Object, LineIndex As Long) As String Dim lc&, linechar& linechar = SendMessageBynum(CTextBox.hwnd, EM_LINEINDEX, LineIndex, 0) lc = SendMessageBynum(CTextBox.hwnd, EM_LINELENGTH, linechar, 0) + 1 GetLineText = String(lc + 2, 0) Mid$(GetLineText, 1, 1) = Chr(lc And &HFF) 'Mid$(GetLineText, 2, 1) = Chr(lc &H100) lc = SendMessageByString(CTextBox.hwnd, EM_GETLINE, LineIndex, GetLineText) GetLineText = Left(GetLineText, lc) End Function '**************************************** Private Sub Command1_Click() Text1.Text = GetLineText(RichTextBox1, Int(Text2.Text)) '提取RichTextBox第text2.text行的数据 Text3.Text = GetLineText(RichTextBox1, Int(Text2.Text) + 51) '提取第二个字段的数据 End Sub 按钮按了后,数字、字母都能显示,但中文就是乱码了 请大侠帮忙!!!!!!!!!!!谢谢了 |
|
|
|
99
修改
删除
举报
引用
回复
| |