【ASP.NET開発】ADO.NET呼び出し帯域出力パラメータの格納プロセス


public static void QueryList()
        {
            SqlConnection con = new SqlConnection("        ");
            SqlCommand cmd = new SqlCommand("      ", con);
            //       
            cmd.CommandType = CommandType.StoredProcedure;

            SqlParameter[] para ={
                                     new SqlParameter("  1",SqlDbType.Int),
                                     new SqlParameter("  2",SqlDbType.Int),
                                     new SqlParameter("  3",SqlDbType.Int),
                                     new SqlParameter("  4",SqlDbType.Int)

            };

            para[0].Value = 3;
            para[1].Value = 4;
            para[2].Direction = ParameterDirection.Output;  //         
            para[3].Direction = ParameterDirection.Output;

            cmd.Parameters.AddRange(para);//          
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adapter.Fill(dt);

            foreach (DataRow dr in dt.Rows)
            {
                Console.WriteLine(dr[0].ToString());
            }

            int pageCount = Convert.ToInt32(cmd.Parameters[2].Value);
            int rowCount = Convert.ToInt32(cmd.Parameters[3].Value);

            Console.WriteLine("PageCount=" + pageCount + ",rowCount=" + rowCount);
        }