/// <summary>
/// Execute a stored procedure or a Sql command that does not return query result.
/// </summary>
/// <param name="connStr"></param>
/// <param name="commandText"></param>
/// <param name="isStoredProcedure"></param>
/// <param name="sqlParams"></param>
/// <returns></returns>
public static int ExecNonQuery(string connStr, string commandText, bool isStoredProcedure, params SqlParameter[] sqlParams)
{
ExecCommandReturn ret = ExecCommand0(connStr, commandText, isStoredProcedure, false, sqlParams);
return(ret.RowAffected);
}
/// <summary>
/// Execute a stored procedure or Sql commadn that return query result.
/// </summary>
/// <param name="connStr"></param>
/// <param name="commandText"></param>
/// <param name="isStoredProcedure"></param>
/// <param name="sqlParams"></param>
/// <returns></returns>
public static DataTable ExecQuery(string connStr, string commandText, bool isStoredProcedure, params SqlParameter[] sqlParams)
{
ExecCommandReturn ret = ExecCommand0(connStr, commandText, isStoredProcedure, true, sqlParams);
return(ret.DataTable);
}
