mcs/class/Mono.Data/DataTools.cs

   1 //\r
   2 // Mono.Data.DataTools\r
   3 //\r
   4 // Authors:\r
   5 //   Brian Ritchie (brianlritchie@hotmail.com) \r
   6 //  \r
   7 //\r
   8 // Copyright (C) Brian Ritchie, 2002\r
   9 // \r
  10 //\r
  11 using System;\r
  12 using System.Data;\r
  13 \r
  14 namespace Mono.Data\r
  15 {\r
  16         /// <summary>\r
  17         /// Summary description for ProviderTools.\r
  18         /// </summary>\r
  19         public class DataTools\r
  20         {\r
  21                 public DataTools()\r
  22                 {\r
  23                 }\r
  24 \r
  25                 static public IDataParameter AddParameter(IDbCommand Cmd, string ParameterName, DbType DbType, \r
  26                         ParameterDirection Direction)\r
  27                 {\r
  28                         IDataParameter param=Cmd.CreateParameter();\r
  29                         Cmd.Parameters.Add(param);\r
  30                         param.ParameterName=ParameterName;\r
  31                         param.Direction=Direction;\r
  32                         param.DbType=DbType;\r
  33                         return param;\r
  34                 }\r
  35 \r
  36                 static public IDataParameter AddParameter(IDbCommand Cmd, string ParameterName, DbType DbType)\r
  37                 {\r
  38                         IDataParameter param=Cmd.CreateParameter();\r
  39                         Cmd.Parameters.Add(param);\r
  40                         param.ParameterName=ParameterName;\r
  41                         param.DbType=DbType;\r
  42                         return param;\r
  43                 }\r
  44 \r
  45                 static public DataSet FillDataSet(IDbConnection conn, string SelectCommand)\r
  46                 {\r
  47                         DataSet ds=new DataSet();\r
  48                         IDbDataAdapter adapter=ProviderFactory.CreateDataAdapter(conn, SelectCommand);\r
  49                         if (conn.State!=ConnectionState.Open)\r
  50                                 conn.Open();\r
  51                         adapter.Fill(ds);\r
  52                         return ds;\r
  53                 }\r
  54 \r
  55                 static public DataSet FillDataSet(IDbCommand SelectCommand)\r
  56                 {\r
  57                         DataSet ds=new DataSet();\r
  58                         IDbDataAdapter adapter=ProviderFactory.CreateDataAdapter(SelectCommand);\r
  59                         if (adapter.SelectCommand.Connection.State!=ConnectionState.Open)\r
  60                                 adapter.SelectCommand.Connection.Open();\r
  61                         adapter.Fill(ds);\r
  62                         return ds;\r
  63                 }\r
  64 \r
  65                 static public DataSet FillDataSet(string ConfigSetting, string SelectCommand)\r
  66                 {\r
  67                         IDbConnection conn=ProviderFactory.CreateConnectionFromConfig(ConfigSetting);\r
  68                         conn.Open();\r
  69                         DataSet ds=null;\r
  70                         try\r
  71                         {\r
  72                                 ds=new DataSet();\r
  73                                 IDbDataAdapter adapter=ProviderFactory.CreateDataAdapter(conn, SelectCommand);\r
  74                                 adapter.Fill(ds);\r
  75                         }\r
  76                         finally\r
  77                         {\r
  78                                 conn.Close();\r
  79                         }\r
  80                         return ds;\r
  81                 }\r
  82 \r
  83 \r
  84         }\r
  85 }\r