2 // Mono.Data.DataTools
\r
5 // Brian Ritchie (brianlritchie@hotmail.com)
\r
8 // Copyright (C) Brian Ritchie, 2002
\r
17 /// Summary description for ProviderTools.
\r
19 public class DataTools
\r
25 static public IDataParameter AddParameter(IDbCommand Cmd, string ParameterName, DbType DbType,
\r
26 ParameterDirection Direction)
\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
36 static public IDataParameter AddParameter(IDbCommand Cmd, string ParameterName, DbType DbType)
\r
38 IDataParameter param=Cmd.CreateParameter();
\r
39 Cmd.Parameters.Add(param);
\r
40 param.ParameterName=ParameterName;
\r
41 param.DbType=DbType;
\r
45 static public DataSet FillDataSet(IDbConnection conn, string SelectCommand)
\r
47 DataSet ds=new DataSet();
\r
48 IDbDataAdapter adapter=ProviderFactory.CreateDataAdapter(conn, SelectCommand);
\r
49 if (conn.State!=ConnectionState.Open)
\r
55 static public DataSet FillDataSet(IDbCommand SelectCommand)
\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
65 static public DataSet FillDataSet(string ConfigSetting, string SelectCommand)
\r
67 IDbConnection conn=ProviderFactory.CreateConnectionFromConfig(ConfigSetting);
\r
73 IDbDataAdapter adapter=ProviderFactory.CreateDataAdapter(conn, SelectCommand);
\r