OdbcParameter.cs 3.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188
  1. //
  2. // System.Data.Odbc.OdbcParameter
  3. //
  4. // Authors:
  5. // Brian Ritchie ([email protected])
  6. //
  7. // Copyright (C) Brian Ritchie, 2002
  8. //
  9. using System;
  10. using System.Data;
  11. using System.Data.Common;
  12. namespace System.Data.Odbc
  13. {
  14. public sealed class OdbcParameter : MarshalByRefObject, IDbDataParameter,
  15. IDataParameter, ICloneable
  16. {
  17. #region Fields
  18. string name;
  19. object value;
  20. int size;
  21. bool isNullable;
  22. byte precision;
  23. byte scale;
  24. DataRowVersion sourceVersion;
  25. string sourceColumn;
  26. ParameterDirection direction;
  27. OdbcType odbcType;
  28. DbType dbType;
  29. int IntValue;
  30. #endregion
  31. #region Constructors
  32. public OdbcParameter ()
  33. {
  34. name = String.Empty;
  35. value = null;
  36. size = 0;
  37. isNullable = true;
  38. precision = 0;
  39. scale = 0;
  40. sourceColumn = String.Empty;
  41. }
  42. public OdbcParameter (string name, object value)
  43. : this ()
  44. {
  45. this.name = name;
  46. this.value = value;
  47. }
  48. public OdbcParameter (string name, OdbcType dataType)
  49. : this ()
  50. {
  51. this.name = name;
  52. OdbcType = dataType;
  53. }
  54. public OdbcParameter (string name, OdbcType dataType, int size)
  55. : this (name, dataType)
  56. {
  57. this.size = size;
  58. }
  59. public OdbcParameter (string name, OdbcType dataType, int size, string
  60. srcColumn)
  61. : this (name, dataType, size)
  62. {
  63. this.sourceColumn = srcColumn;
  64. }
  65. public OdbcParameter(string name, OdbcType dataType, int size,
  66. ParameterDirection direction, bool isNullable, byte precision, byte scale,
  67. string srcColumn, DataRowVersion srcVersion, object value)
  68. : this (name, dataType, size, srcColumn)
  69. {
  70. this.direction = direction;
  71. this.isNullable = isNullable;
  72. this.precision = precision;
  73. this.scale = scale;
  74. this.sourceVersion = srcVersion;
  75. this.value = value;
  76. }
  77. #endregion
  78. #region Properties
  79. public DbType DbType {
  80. get { return dbType; }
  81. set {
  82. dbType = value;
  83. }
  84. }
  85. public ParameterDirection Direction {
  86. get { return direction; }
  87. set { direction = value; }
  88. }
  89. public bool IsNullable {
  90. get { return isNullable; }
  91. }
  92. public OdbcType OdbcType {
  93. get { return odbcType; }
  94. set {
  95. odbcType = value;
  96. }
  97. }
  98. public string ParameterName {
  99. get { return name; }
  100. set { name = value; }
  101. }
  102. public byte Precision {
  103. get { return precision; }
  104. set { precision = value; }
  105. }
  106. public byte Scale {
  107. get { return scale; }
  108. set { scale = value; }
  109. }
  110. public int Size {
  111. get { return size; }
  112. set { size = value; }
  113. }
  114. public string SourceColumn {
  115. get { return sourceColumn; }
  116. set { sourceColumn = value; }
  117. }
  118. public DataRowVersion SourceVersion {
  119. get { return sourceVersion; }
  120. set { sourceVersion = value; }
  121. }
  122. public object Value {
  123. get {
  124. return IntValue;
  125. }
  126. set { this.IntValue =(int) value; }
  127. }
  128. #endregion // Properties
  129. #region Internal Properties
  130. internal void Bind(int hstmt,int ParamNum)
  131. {
  132. if (OdbcType==OdbcType.Integer)
  133. {
  134. OdbcReturn ret=libodbc.SQLBindParam(hstmt, Convert.ToInt16(ParamNum), 4,
  135. 4, 0,0,ref IntValue, 0);
  136. libodbc.DisplayError("SQLBindParam",ret);
  137. }
  138. else Console.WriteLine("Unknown Paramter Type");
  139. }
  140. #endregion // Internal Properties
  141. #region Methods
  142. [MonoTODO]
  143. object ICloneable.Clone ()
  144. {
  145. throw new NotImplementedException ();
  146. }
  147. public override string ToString ()
  148. {
  149. return ParameterName;
  150. }
  151. #endregion
  152. }
  153. }