SqlCommandTextEditor.cs 2.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. // ByteFX.Data data access components for .Net
  2. // Copyright (C) 2002-2003 ByteFX, Inc.
  3. //
  4. // This library is free software; you can redistribute it and/or
  5. // modify it under the terms of the GNU Lesser General Public
  6. // License as published by the Free Software Foundation; either
  7. // version 2.1 of the License, or (at your option) any later version.
  8. //
  9. // This library is distributed in the hope that it will be useful,
  10. // but WITHOUT ANY WARRANTY; without even the implied warranty of
  11. // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
  12. // Lesser General Public License for more details.
  13. //
  14. // You should have received a copy of the GNU Lesser General Public
  15. // License along with this library; if not, write to the Free Software
  16. // Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
  17. #if WINDOWS
  18. using System;
  19. using System.Windows.Forms;
  20. using System.Drawing.Design;
  21. namespace ByteFX.Data.Common
  22. {
  23. /// <summary>
  24. /// Summary description for MySqlConnectionDesign.
  25. /// </summary>
  26. internal class SqlCommandTextEditor : UITypeEditor
  27. {
  28. public override System.Drawing.Design.UITypeEditorEditStyle GetEditStyle(System.ComponentModel.ITypeDescriptorContext context)
  29. {
  30. return System.Drawing.Design.UITypeEditorEditStyle.Modal;
  31. }
  32. public override bool GetPaintValueSupported(System.ComponentModel.ITypeDescriptorContext context)
  33. {
  34. return false;
  35. }
  36. public override object EditValue(System.ComponentModel.ITypeDescriptorContext context, System.IServiceProvider provider, object value)
  37. {
  38. System.Data.IDbCommand command = (System.Data.IDbCommand)context.Instance;
  39. if (command.Connection == null)
  40. {
  41. MessageBox.Show("Connection property not set to a valid connection.\n"+
  42. "Please set and try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
  43. return value;
  44. }
  45. SqlCommandEditorDlg dlg = new SqlCommandEditorDlg( command );
  46. dlg.SQL = (string)value;
  47. if(dlg.ShowDialog() == DialogResult.OK)
  48. {
  49. return dlg.SQL;
  50. }
  51. else
  52. return value;
  53. }
  54. }
  55. }
  56. #endif