using CRecordset class to insert data into database using mfc

// TODO: Add your control notification handler code here

	CDatabase cd;	

	if(cd.OpenEx ("DSN=SampleData",0 ))
		MessageBox("connected");
	
	if(cd.BeginTrans ())
		MessageBox("BeginTrans");

	CRecordset rd(&cd);
	if(rd.Open (CRecordset::dynaset, _T("Select * from Sample")))
		MessageBox ("recordset opened");
	
	CString str;	
	rd.GetFieldValue("Name",str);      // Data retrived from the database.....
	MessageBox(str);
	rd.Close ();
	cd.Close ();