int game_year=Convert.Toint32(reader_game.ToString());
请先在SQL Server中创建以下存储过程: CREATE PROCEDURE [dbo].[P_GetCount] ( @count [int] OUTPUT ) AS select @count=count(*) from soccer_systemGO然后在需要用到记录数的地方放置以下代码: conn.Open(); SqlCommand Cmd1=new SqlCommand(); Cmd1.CommandType=CommandType.StoredProcedure; Cmd1.CommandText="P_GetCount"; Cmd1.Connection=conn; SqlParameter ParaArray=null; ParaArray=Cmd1.Parameters.Add("@count",SqlDbType.Int); ParaArray.Direction=ParameterDirection.Output; Cmd1.ExecuteNonQuery(); int count=CmmdGetTime.Parameters["@count"].Value; 变量count中就保存了你所要的记录数
int game=Convert.Toint32(reader_game.GetValue(0)); int game_year=Convert.Toint32(reader_game.GetValue(1));
int game=reader_game.GetInt32(0); int game_year=reader_game.GetInt32(1); orint game = Convert.ToInt32(reader_game["game"]); int game_year= Convert.ToInt32(reader_game["game_year"]);
while(reader_game.Read()) { int game=reader_game.GetInt32(0); int game_year=reader_game.GetInt32(1); }
int game=reader_game.GetInt32(0); int game_year=reader_game.GetInt32(1); 有的时候不一定读得出来,数据库的东西很难讲的,可以这样 int game=int.Parse(reader_game.GetObject(0)); int game_year=int.Parse(reader_game.GetObject(1));
CREATE PROCEDURE [dbo].[P_GetCount]
( @count [int] OUTPUT
)
AS
select @count=count(*) from soccer_systemGO然后在需要用到记录数的地方放置以下代码:
conn.Open();
SqlCommand Cmd1=new SqlCommand();
Cmd1.CommandType=CommandType.StoredProcedure;
Cmd1.CommandText="P_GetCount";
Cmd1.Connection=conn;
SqlParameter ParaArray=null;
ParaArray=Cmd1.Parameters.Add("@count",SqlDbType.Int);
ParaArray.Direction=ParameterDirection.Output;
Cmd1.ExecuteNonQuery();
int count=CmmdGetTime.Parameters["@count"].Value;
变量count中就保存了你所要的记录数
int game_year=Convert.Toint32(reader_game.GetValue(1));
int game_year=reader_game.GetInt32(1);
orint game = Convert.ToInt32(reader_game["game"]);
int game_year= Convert.ToInt32(reader_game["game_year"]);
{
int game=reader_game.GetInt32(0);
int game_year=reader_game.GetInt32(1);
}
int game_year=reader_game.GetInt32(1);
有的时候不一定读得出来,数据库的东西很难讲的,可以这样
int game=int.Parse(reader_game.GetObject(0));
int game_year=int.Parse(reader_game.GetObject(1));