Execute storage procedure using c#

            Database bs = new Database();
            bs.StoredProcedureName = "spTest";

            SqlParameter[] param = new SqlParameter[2];

            param[ 0] = new SqlParameter{ParameterName = "Acc"      ,SqlDbType = System.Data.SqlDbType.NVarChar ,Value = Acc,Direction = ParameterDirection.Input};

            param[1] = new SqlParameter{ParameterName = "id"        ,SqlDbType = System.Data.SqlDbType.Int      ,Value = id,Direction = ParameterDirection.Output};



//get the oputput variable
Int32.TryParse(bs.GetParameterValue("id").ToString(), out tempVar)