public DataSet ExecuteQuery(string sCommand, string sTableName, SqlParameter[] aParams, CommandType? Type)Or, better, you could overload ExecuteQuery() to take either three or four parameters....
public DataSet ExecuteQuery(string sCommand, string sTableName, SqlParameter[] aParams) { DataSet.ExecuteQuery(sCommand,sTableName,aParams,CommandType.Text); } public DataSet ExecuteQuery(string sCommand, string sTableName, SqlParameter[] aParams, CommandType Type) { oCommand.CommandType = Type; // etc }>I want to set up the following:
>public DataSet ExecuteQuery(string sCommand, string sTableName, SqlParameter[] aParams) >{ > return ExecuteQuery(sCommand, sTableName, aParams, null); >} >public DataSet ExecuteQuery(string sCommand, string sTableName, SqlParameter[] aParams, CommandType Type) >{ >. >. >. > if (Type == null) > { > Type = CommandType.Text; > } > oCommand.CommandType = Type; > >} >>