首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 开发语言 > C++ Builder >

C++builder 连接Access解决方案

2012-06-08 
C++builder 连接Access哪位大侠有用C++builder连接Access的完成示例代码(用程序连接的) 能给我发一份吗 56

C++builder 连接Access
哪位大侠有用C++builder连接Access的完成示例代码(用程序连接的) 能给我发一份吗 564354093@qq.com 谢谢

[解决办法]
bool __fastcall TfrmWebLogin::ConnectServer(void)
{
FConnectDB = false;

AnsiString UIDb ;
UIDb = "Main.mdb" ;

if (!FileExists(UIDb))
{
FConnectDB = false ;
return FConnectDB;
}

try
{
AdoCN->Connected=false;
AdoCN->ConnectionString =" Provider=Microsoft.Jet.OLEDB.4.0;Data Source= "+UIDb+";Persist Security Info=False";
AdoCN->LoginPrompt = false;
AdoCN->Connected = true;
FConnectDB = true ;
}
catch(...)
{
}
return FConnectDB;




}
[解决办法]
怎么发到茶馆里了。这里是喝茶用的。
[解决办法]

C/C++ code
void __fastcall TDataMod::TelDataInit(void){    String connStr="",tempStr="";    int j=0;    TIniFile *ini;        try        {         ADOConn1->Close();         //  connStr="Provider=SQLOLEDB.1;Password=xzsat;Persist Security Info=True;User ID=sa;Initial Catalog=daw;Data Source=XJQ-SAT";         ini=new TIniFile(".//SAS_Config.ini");         tempStr=ini->ReadString("dataBase","数据库类型","SQLSERVER");         ini->WriteString("dataBase","数据库类型",tempStr);         if(tempStr=="SQLSERVER") //连接SQL SERVER         {            connStr="Provider=SQLOLEDB.1;Persist Security Info=True;";            tempStr=ini->ReadString("dataBase","密码","xzsat");            ini->WriteString("dataBase","密码",tempStr);            connStr+="Password="+tempStr+";" ;            tempStr=ini->ReadString("dataBase","用户名","sa");            connStr+="User ID="+tempStr+";" ;            ini->WriteString("dataBase","用户名",tempStr);            tempStr=ini->ReadString("dataBase","数据库名称","daw");            connStr+="Initial Catalog="+tempStr+";" ;            ini->WriteString("dataBase","数据库名称",tempStr);            tempStr=ini->ReadString("dataBase","服务器名(IP)","XJQ-SAT");            connStr+="Data Source="+tempStr+" " ;             ini->WriteString("dataBase","服务器名(IP)",tempStr);         }         else       //连接ACCESS         {           // Provider=Microsoft.Jet.OLEDB.4.0;Password=123;Data Source=E:\VehData.mdb;Persist Security Info=True            connStr="Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=True;";            tempStr=ini->ReadString("dataBase","密码","");            ini->WriteString("dataBase","密码",tempStr);            connStr+="Password="+tempStr+";" ;            //tempStr=ini->ReadString("dataBase","用户名","Admin");            //connStr+="User ID="+tempStr+";" ;            //ini->WriteString("dataBase","用户名",tempStr);            tempStr=ini->ReadString("dataBase","数据库名称","E:\VehData.mdb");            connStr+="Data Source="+tempStr+";" ;            ini->WriteString("dataBase","数据库名称",tempStr);         }         delete ini;         ADOConn1->ConnectionString=connStr;         ADOConn1->Open();         if(ADOConn1->Connected)         {         //Memo1->Lines->Add("数据库连接成功……");         TStringList* List=new TStringList;         tempStr="UserTable";         ADOConn1->GetTableNames(List,false);            for(j=0;j<List->Count;j++)            {                if(tempStr==(List->Strings[j]))                  break;            }            if(j>=List->Count)                AddUserTable();            UserTable->Close();            UserTable->TableName=tempStr;            UserTable->Open();            UserTable->Last();            tempStr= FormatDateTime("'Veh_'yyyymm",Date());            for(j=0;j<List->Count;j++)            {                if(tempStr==(List->Strings[j]))                break;            }            if(j>=List->Count)                AddDataTable();            InsertTable->Close();            DisplayTable->Close();            InsertTable->TableName=tempStr;            DisplayTable->TableName=tempStr;            //InsertTable->Open();            //InsertTable->Last();            delete  List;            DelDataTable();            try            {              String  SqlStr="Select Top 100 * from  ";                SqlStr+=tempStr;                SqlStr+=" order by VEH_ID desc";                DataMod->InsertQuery->Close();                DataMod->InsertQuery->SQL->Clear();                DataMod->InsertQuery->SQL->Add(SqlStr);                DataMod->InsertQuery->ExecSQL();                DataMod->InsertQuery->Open();            }            catch(...)            {            }         }                 }        catch(...)        {        //         ShowMessage("远程数据库连接失败,\n请检查网络连接和服务器!");        }} 

热点排行