關於C#程式無法取得sqlserver的output參數

 

cmd.Parameters.Add("@TotalRecords", SqlDbType.Int);
                cmd.Parameters["@TotalRecords"].Direction = ParameterDirection.Output;
                reader = cmd.ExecuteReader();
while (reader.Read())
                {
//...
                }
                TotalRecords = Convert.ToInt32(cmd.Parameters["@TotalRecords"].Value);

 

 

 

 

DataReader對象是獨佔串連的，不關DataReader返回參數值取不出來的
所以在TotalRecords = Convert.ToInt32(cmd.Parameters["@TotalRecords"].Value);前必須先把reader關閉

 

cmd.Parameters.Add("@TotalRecords", SqlDbType.Int);
                cmd.Parameters["@TotalRecords"].Direction = ParameterDirection.Output;
                reader = cmd.ExecuteReader();
while (reader.Read())
                {
//...
                }
                reader.Close();
                TotalRecords = Convert.ToInt32(cmd.Parameters["@TotalRecords"].Value);