数据库问题,100冰儿请您指点

[binger]

我有数据库c:\data\test.mdb,表名为ziliao,有一字段为name,请教在vc++6.0下用
ado,odbc两种方法的详细操作步骤:如何连接打开数据库,如何读出第2个name字段,应用
这两种方法需要什么条件,我是初学者,请您改我详细的程序解答,谢谢!

[zzh]

见下面步骤：
1、ODBC
设置ODBC DSN，假设为ZILIAO，从CRecordset类派生出一个类CZiLiaoTable，该类所对应的表为ziliao
CDatabase db;
db.Open("ZILIAO",FALSE,FALSE,"ODBC;",TRUE);
CZiLiaoTable m_Set(&db);
m_Set.Open(CRecordset::snapshot,"select name from ziliao");
while(!m_set.IsEOF())
{
TRACE("%s",m_Set.m_name);

}
m_set.Close();
db.Close();

[zzh]

见下面步骤：
1、ODBC
设置ODBC DSN，假设为ZILIAO，从CRecordset类派生出一个类CZiLiaoTable，该类所对应的表为ziliao
CDatabase db;
db.Open("ZILIAO",FALSE,FALSE,"ODBC;",TRUE);
CZiLiaoTable m_Set(&db);
m_Set.Open(CRecordset::snapshot,"select name from ziliao");
while(!m_set.IsEOF())
{
TRACE("%s",m_Set.m_name);

}
m_set.Close();
db.Close();
如果只是读取该记录，也可以如下：
CDatabase db;
db.Open("ZILIAO",FALSE,FALSE,"ODBC;",TRUE);
CRecordset m_Set(&db);
m_Set.Open(CRecordset::snapshot,"select * from ziliao");
while(!m_Set.IsEOF())
{
TRACE("%s",m_Set.GetFieldValue("NAME");//第二个字段
}
m_Set.Close();
db.Close();
2、ADO方式
_ConnectionPtr MyDb;
MyDb.CreateInstance(__uuidof(Connection));
MyDb->Open("DSN=ziliao;UID=sa;PWD=","","",-1);
_RecordsetPtr MySet;
MySet.CreateInstance(__uuidof(Recordset));
MySet->Open ("select * from name",MyDb.GetInterfacePtr (),adOpenDynamic,adLockOptimistic,adCmdUnknown);
HRESULT rs=MySet->MoveFirst ();
while(!MySet->EndOfFile )
{
MySet->GetCollect (_variant_t("name"));
rs=MySet->MoveNext ();
}
如果还有问题，可以参孝开发文档当中的几篇数据库文章

[zzh]

1、设置ODBC数据源，假设为TEST
ADO方式：
_ConnectionPtr MyDb;
MyDb.CreateInstance(__uuidof(Connection));
MyDb->Open("DSN=TEST;UID=sa;PWD=","","",-1);
_RecordsetPtr MySet;
MySet.CreateInstance(__uuidof(Recordset));
MySet->Open ("select * from name",MyDb.GetInterfacePtr (),adOpenDynamic,adLockOptimistic,adCmdUnknown);
HRESULT rs=MySet->MoveFirst ();
while(!MySet->EndOfFile )
{
MySet->GetCollect (_variant_t("name"));
mySet->MoveNext();
}
MySet.Close();
Mydb.Close();
2、ODBC方式
1、只读取数据
CDatabase db;
db.Open("TEST",FALSE,FALSE,"ODBC;",TRUE);
CRecordset m_Set(&db);
m_Set.Open(CRecordset::snapshot,"select * from name");
while(!m_Set.IsEOF())
{
TRACE("%s",m_Set.GetFieldValue("name");
m_Set.MOveNext();
}
m_Set.Close();
db.Close();

2、从CRecordset派生出一个类CZiLiao，
CDatabase db;
db.Open("Test",FALSE,FALSE,"ODBC;",TRUE);
CZiLiao m_Set(&db);
m_Set.Open(CRecordset::snapshot,"select * from ziliao");
while(!m_Set.IsEOF())
{
TRACE("%s",m_Set.m_name);
m_Set.MoveNext();
}
m_Set.Close();
db.Close(0;

[binger]

DSN不用带路径吗?我的文件在c:\data\test.mdb,应该怎么设置呢?zzh我看过您的vc++开发数据库的系列打作,我现在要设计数据库程序,您能帮我吗?因为我是初学者,能不能给我一些原码?谢谢!!!
[e-mail]