使用Memo数据类型字符串从MS Access DB文件获取字段值的代码段 [英] Code snippet to get field value from MS Access DB file with strings of Memo datatype
本文介绍了使用Memo数据类型字符串从MS Access DB文件获取字段值的代码段的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Hello All,
我有一个MS Access DB文件(Notice.mdb),它有29列和20行Memo数据类型的字符串数据。
我需要VC ++中的代码片段,我可以使用它来检索字符串并将其存储在某些CString数组中。
请帮助
谢谢和问候
Dinesh
Hello All,
I have a MS Access DB file ("Notice.mdb") which has 29 columns & 20 rows of strings data of Memo datatype.
I need a code snippet in VC++ using which i can retrieve the strings and store it in some CString array.
Please help
Thanks & regards
Dinesh
推荐答案
#includeafxdao.h
CString lpszFile = LMyTables.mdb;
CDaoDatabase db;
db.Create(lpszFile);
db.Open(lpszFile);
db.Execute(LCREATE TABLE MyTable (Field1 VARCHAR(20),Field2 VARCHAR(20)););
db.Execute(LINSERT INTO MyTable(Field1,Field2)VALUES(' value11','value12'););
db.Execute(LINSERT INTO MyTable(Field1,Field2)VALUES('value21','value22'););
CDaoRecordset记录集(&db);
recordset.Open(AFX_DA O_USE_DEFAULT_TYPE,LSELECT * FROM MyTable;,0);
COleVariant olevarValue1;
COleVariant olevarValue2;
while(!recordset.IsEOF())
{
olevarValue1.ChangeType(VT_BSTR,NULL);
olevarValue2.ChangeType(VT_BSTR,NULL);
recordset.GetFieldValue(LField1,olevarValue1);
recordset.GetFieldValue(LField2,olevarValue2 );
printf(Value1:%s \ n,(LPCTSTR)olevarValue1.bstrVal);
printf(Value2:%s \ n, (LPCTSTR)olevarValue2.bstrVal);
recordset.MoveNext();
}
#include "afxdao.h"
CString lpszFile = L"MyTables.mdb";
CDaoDatabase db;
db.Create(lpszFile);
db.Open(lpszFile);
db.Execute(L"CREATE TABLE MyTable (Field1 VARCHAR(20), Field2 VARCHAR(20));");
db.Execute(L"INSERT INTO MyTable(Field1, Field2) VALUES ('value11', 'value12');");
db.Execute(L"INSERT INTO MyTable(Field1, Field2) VALUES ('value21', 'value22');");
CDaoRecordset recordset(&db);
recordset.Open(AFX_DAO_USE_DEFAULT_TYPE, L"SELECT * FROM MyTable;", 0);
COleVariant olevarValue1;
COleVariant olevarValue2;
while(!recordset.IsEOF())
{
olevarValue1.ChangeType(VT_BSTR, NULL);
olevarValue2.ChangeType(VT_BSTR, NULL);
recordset.GetFieldValue(L"Field1", olevarValue1);
recordset.GetFieldValue(L"Field2", olevarValue2);
printf("Value1: %s\n", (LPCTSTR)olevarValue1.bstrVal);
printf("Value2: %s\n", (LPCTSTR)olevarValue2.bstrVal);
recordset.MoveNext();
}
这篇关于使用Memo数据类型字符串从MS Access DB文件获取字段值的代码段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文