Guest User

Untitled

a guest
Jun 13th, 2018
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.94 KB | None | 0 0
  1. SELECT `textb` FROM `table_name` WHERE id_textb = 1
  2.  
  3. Memo1.Text := textBStr;
  4.  
  5. procedure TForm2.FormCreate(Sender: TObject);
  6. const
  7. { Connection string }
  8. ConnString =
  9. 'Provider=SQLOLEDB.1;Persist Security Info=False;' +
  10. 'User ID=%s;Password=%s;Data Source=%s;Use Procedure for Prepare=1;' +
  11. 'Auto Translate=True;Packet Size=4096;Use Encryption for Data=False;'+
  12. 'Tag with column collation when possible=False';
  13.  
  14. { SQL Query }
  15. SQLStr = 'SELECT * FROM customer WHERE customer_id = :AnId;';
  16.  
  17. { User access }
  18. UserName = 'db_user_name';
  19. PassWord = 'db_pass_word';
  20. Server = 'my.db.server';
  21.  
  22. var
  23. ADOConn : TADOConnection;
  24. ADOQuery : TADOQuery;
  25. DataSrc : TDataSource;
  26. Param : TParameter;
  27.  
  28. begin
  29. { Create an ADO connection }
  30. ADOConn := TADOConnection.Create(Self);
  31. { Setup the provider engine }
  32.  
  33. { Setup the connection string }
  34. ADOConn.ConnectionString := Format(ConnString,
  35. [UserName, PassWord, Server]);
  36.  
  37. { Disable login prompt }
  38. ADOConn.LoginPrompt := False;
  39.  
  40. try
  41. ADOConn.Connected := True;
  42. except
  43. on e: EADOError do
  44. begin
  45. MessageDlg('Error while connecting', mtError,
  46. [mbOK], 0);
  47.  
  48. Exit;
  49. end;
  50. end;
  51.  
  52. { Create the query }
  53. ADOQuery := TADOQuery.Create(Self);
  54. ADOQuery.Connection := ADOConn;
  55. ADOQuery.SQL.Add(SQLStr);
  56.  
  57. { Update the parameter that was parsed from the SQL query: AnId }
  58. Param := ADOQuery.Parameters.ParamByName('AnId');
  59. Param.DataType := ftInteger;
  60. Param.Value := 1;
  61.  
  62. { Set the query to Prepared - will improve performance }
  63. ADOQuery.Prepared := true;
  64.  
  65. try
  66. ADOQuery.Active := True;
  67. except
  68. on e: EADOError do
  69. begin
  70. MessageDlg('Error while doing query', mtError,
  71. [mbOK], 0);
  72.  
  73. Exit;
  74. end;
  75. end;
  76.  
  77. { Create the data source }
  78. DataSrc := TDataSource.Create(Self);
  79. DataSrc.DataSet := ADOQuery;
  80. DataSrc.Enabled := true;
  81.  
  82. { Finally initilalize the grid }
  83. DBGrid1.DataSource := DataSrc;
  84. end;
Add Comment
Please, Sign In to add comment