在builder中关联MS SQL Server
请问,我想在builder里面用Microsoft SQL server 2000作为数据库,但是不知道加什么控件,也不知道应该怎么让它们关联,怎么运行SQL 语句?还有,ADOQuery如何使用?请大家帮帮忙吧!
[解决办法]
如果是sqlserver,一般可用TADOConnection+TADOQuery
TADOConnection用于连接数据库,TADOQuery中可以写SQL
[解决办法]
//ADOConnection1 和 ADOQuery1 控件AnsiString Conn ;Conn = "Provider=SQLOLEDB.1;";//设置连接驱动 Conn += "Persist Security Info=True;"; Conn += "Password="+DBPassword+";";//设置密码 Conn += "User ID="+DBUserID+";";//设置用户名 Conn += "Data Source="+DBServer+";";//设置服务器 Conn += "Initial Catalog="+DBName+";";//设置数据库 ADOQuery1->Connection = ADOConnection1;ADOConnection1->ConnectionString = Conn ;ADOConnection1->Open() ;AnsiString SQL ="select *from tableName ";ADOQuery1->Close();ADOQuery1->SQL->Clear();ADOQuery1->SQL->Add(SQL);ADOQuery1->Open();