|
怎样在自己的进销存里导入速达、管家婆和用友的数据(10) begin inherited; OpenDlg.FileName := edtYYData.Text; if OpenDlg.Execute then begin sFileName := OpenDlg.FileName; edtYYData.Text := sFileName; end; end; function TfrmUpdateSD3000.ConectGrASP(sData: string): Boolean; var sServer, sName, sPass: string; begin sServer := edtServeName.Text; sName := edtLoginName.Text; sPass := edtLoginPass.Text; if Trim(sServer) = '' then sServer := 'LocalHost'; if Trim(sName) = '' then sName := 'sa'; with SQLADOConnet do begin if Connected = True then Close; ConnectionString := GetSQLConnectionString(sServer, sData, sName, sPass); LoginPrompt := False; Open(sName, sPass); Result := Connected; end; end; procedure TfrmUpdateSD3000.bbLinkServerClick(Sender: TObject); var sSql, sName, sTmp: string; begin inherited; sSql := 'SELECT * FROM sysdatabases WHERE (dbid > 5)'; sName := 'Name'; sTmp := ''; if ConectGrASP('Master') then begin if OpenDataSetEx(SQLADOConnet, SQLDataSet, sSql) then begin TableToStrings2(SQLDataSet, sName, sTmp, sTmp, #13); cbxSQLDB.Items.Text := sName; if cbxSQLDB.Items.Count > 0 then cbxSQLDB.ItemIndex := 0; end; end else ShowMsg('连接SQLServer数据库出错,请重新输入服务器名、用户名、密码!');
|