C
Curious
I have a stored procedure that SELECTs records that match certain
restriction:
CREATE PROCEDURE dbo.algo_get_longterm_limits
(
@date AS DateTime
)
AS
SELECT asof_date, sec_id, shares, price, trade
FROM dbo.algo_longterm_limit
WHERE asof_date = @date
In my C#.NET code, how can I stored the recordset from running this
stored procedure into an ArrayList? Currently I have code as below
which does not catch the recordset:
DateTime dt = DateTime.Parse(day);
IDbCommand command = mConn.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText =
"db_dynamic_trading.dbo.algo_get_longterm_limits";
command.Parameters.Add(new SqlParameter("@date",
day));
command.ExecuteNonQuery();
Any advice on how to stored the recordset into some variable such as
ArrayList in C#.NET?
Thanks!
restriction:
CREATE PROCEDURE dbo.algo_get_longterm_limits
(
@date AS DateTime
)
AS
SELECT asof_date, sec_id, shares, price, trade
FROM dbo.algo_longterm_limit
WHERE asof_date = @date
In my C#.NET code, how can I stored the recordset from running this
stored procedure into an ArrayList? Currently I have code as below
which does not catch the recordset:
DateTime dt = DateTime.Parse(day);
IDbCommand command = mConn.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText =
"db_dynamic_trading.dbo.algo_get_longterm_limits";
command.Parameters.Add(new SqlParameter("@date",
day));
command.ExecuteNonQuery();
Any advice on how to stored the recordset into some variable such as
ArrayList in C#.NET?
Thanks!